Power BI how to un-filter a Single Page

Подписаться 90 тыс.

Просмотров 2,3 тыс.

50% 1

⚡⚡⚡ 3 methods to have 1 page filtered differently to the rest ⚡⚡⚡
00:00 The Introduction
01:51 The Basic Simple Approach - Filter Each Page Manually
02:40 The Basic Approach 2: Publish and create a linked report then publish as App
04:28 The Hack using a calculation group
Great trick thanks to Owen Auger / owenauger and via Phil Seamark dax.tips/2021/05/03/power-bi-...
You can download the file here
aasolutions.sharepoint.com/:u...
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

Хобби

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@owenauger 3 месяца назад

Awesome! Thanks for posting Wyn! 🙏

@AccessAnalytic 3 месяца назад

Cheers for the trick!

@chrism9037 3 месяца назад

Very cool hack, thanks Wyn!

@AccessAnalytic 3 месяца назад

No worries 😀

@mienzillaz 3 месяца назад

since you kindly asked Wyn i have a better solution for you :) do it twice! make first cal group to remove items of your choice (you can provide them manually, or whatever you logic will be) and apply it as global filter. Then make second group to ignore filters from the first and apply on a single page.

@AccessAnalytic 3 месяца назад

Hi, thanks. I did try that approach but just couldn’t get it to work

@mienzillaz 3 месяца назад

@@AccessAnalytic cleaning my car atm, will drop DAX a bit later.

@mienzillaz 3 месяца назад

@@AccessAnalytic VAR _excl = {"poggy"} VAR _incl = EXCEPT(VALUES(clubResult[name]),_excl) RETURN CALCULATE( SELECTEDMEASURE(), clubResult[name] in _incl) ####### CALCULATE(SELECTEDMEASURE(),REMOVEFILTERS('Calculation group'), clubResult[name] IN {"poggy"})

@carljime 3 месяца назад

How did you do the graphs on IBC v budget? To specify the variance in the column. Thanks for the videos

@AccessAnalytic 3 месяца назад

Check out this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4Kn9jmgUlnY.htmlsi=motbZm5DukbfTSP6

@cheikhhakim5864 2 месяца назад

thank you sir , as usual well explained , please can you explain an a video how we use the dynamic segmentation to do an aged balance ( for customer) by defining rules for example (Last 30 days; Between 31 and 60 days;Between 61 and 120 days;Between 121 and 180 days....) thanks in advance

@AccessAnalytic 2 месяца назад

You’re welcome. I’d try to use column by examples on my date table in power query.

@cheikhhakim5864 2 месяца назад

@@AccessAnalytic thank you Wyn i am grateful

@mkcorrea 3 месяца назад

Your posted videos are very useful, thanks. But I got confused about this one. Let me see if I got the point.. Using calculated group for original customers table you've filtered all pages, except one page which uses another table, an duplicated customer table. That's it? Appreciating your hacks here from Brazil!

@AccessAnalytic 3 месяца назад

Yes, but without the calculation group you can’t remove the filter from the last page, in order to reapply a different filter

@mkcorrea 3 месяца назад

@@AccessAnalytic Got it! Thanks a lot