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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Show and hide visual filter not working for gauge visual

I am using measure filters to show and hide different visuals, it works fine for my line chart but for my gauge visual , when I apply the measure to filter on this visual, nothing happens if I click on the drop down value 

 

aqsa31_0-1681407863473.png

I am using this measure to filter 

 

hide = if(CALCULATE(SUMX(VALUES(Merged[Client]),[Distinct Years]),ALLSELECTED(Merged)) > 1,1,0)
 
I tried converting it to a column but it started giving me wrong values 
first one is the measure and second is the column 
 
aqsa31_2-1681407943109.png

What possible options do I have to make this work?

3 REPLIES 3
lbendlin
Super User
Super User

I am using measure filters to show and hide different visuals

Do you mean "show and hide individual data points" ?

Anonymous
Not applicable

I am not aware of a way to show or hide visuals based on filters. Best I have seen so far is layering visuals on top of each other and playing with the transparency.  You will lose interactivity with the visual if you do that.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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