Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pegasus
New Member

Multiple responsive filters

Hello,

We all know we can use visuals as a filter example if we have a bar chart of a number of students according to gender, I will have different bars. If we select one bar out of it, All visuals will show data accordingly.

 

My question is if there is one more bar chart of 60 >percent,70>percent,80>percent in a maths test 

 

can I filter it with the visual that boys with 70>percent, I am trying to select both but it is responsive to only one visual filter, we can't select 2 filters visual at once. It is possible in tableau but not in power bi I guess

1 REPLY 1
amitchandak
Super User
Super User

@Pegasus , Create a numeric patameter

 

Then have measure like Assume you have % meausre

calculate([Percent], filter(Values(Table[Student]), [Percent] > [Param]/100) )

 

or

 

if(isfiltered(Table[Student]),  Sumx( filter(Values(Table[Student]), [Percent] > [Param]/100), [Perent] ) , [Percent] )

 

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.