Exclude A Certain Measure/Value From The Page's Slicer Effect On Power BI (Even if the interactions are on)



Let's say you want a static value on your report's page while the page is being filtered by a slicer,
The usual method is to turn off the interaction between the slicer and your value
but what if you have two values on the same chart and you only want to filter one of them by the slicer?!
Quite tricky isn't it?

Well, the answer is really simple here's how:

1- Let's First Take A Look Of How The Error Looks Like

This is obviously wrong! as the slicer affecting both the actual value and maximum value so they are giving the same read 
we want to exclude the max measure so it can get the max of all time without affecting the actual daily read



2- The Answer Is Simple


Let your measure be inside of a CALCULATE function that has ALL filter

3- Let's See The Result 


I changed the day on the slicer couple of times to make sure and it seems about right

4- And Here Is The Case Of Both Values On The Same Chart


Now you don't have to add them on two separate charts!



  • The Slicer can be anything besides a date all you have to do is to add 'ALL' filter to your measurements and you are good to go


Regards.

Comments

Post a Comment

Popular posts from this blog

Integrating Python in Power BI With An Example Of Data Wrangling & Data Visualization

REDUCE Your Measures With Calculation Groups In Power BI

شرح الأداة الرائعة Tabular Editor للـ Power BI