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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Threshold measure to make visual dissappear

I have a visual that looks as follows:

 

Threshold.PNG 

On the right side under team threshold, I want to set it to 1. When filters are chosen accordingly, the visual dissappears. However, for the above card visual, I am not able to select the "Is less than" drop down. So i am not able to change the options.

 

However, if the visual is a bargraph, the dropdown works. Team Threshold is a measure. 

 

Is there any way to make the dropdown work in the card visual? Thank You!

2 REPLIES 2
JosefPrakljacic
Solution Sage
Solution Sage

Could you please share your PBIX File?

 

BR,

Josef

Anonymous
Not applicable

@JosefPrakljacic  Not able to share the pbix file. But this is a sample data.

 

I would do count of ID as a card visual. 

 

Measure 1 (Card Visual) : Responded = 

Responded = CALCULATE(COUNT(Sheet1[ID]), Sheet1[Rating]>0)
 
Measure 2: 
Threshold = IF(CALCULATE(COUNT(Sheet1[ID]), Sheet1[Rating]>0, Sheet1[Level]=1)>822,1,0)
Put this threshold as a visual level filter for the card visuals to set it to 1 (But drop down will not work). When you select Region Fillter as ME, the visual should dissappear. (It does for a bargraph or somehing, but not for a card)
 
Threshold 2.PNG
 
 
 
 
 
 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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