cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bahneby
Frequent Visitor

Hide Visual if too many categories selected

Hello everyone,

 

I would like to hide a clustered column chart, if too many categories are selected from slicer.

 

Bahneby_0-1652434155990.png

 

 

If there are for example more than 4 categories selected, the visual will be too full and one cannot compare the values.

Is there an option to hide the visual, if there are more than 4 categories selected?

 

One option is to put a card in front of the picture, but then, there are no interactions with this visual possible.

I only found solutions, to hide visuals, if exact one category is chosen.

 

Thank you in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Bahneby , Try to create a measure like

if(calculate(distinctcount(category[category]), allselected()) >4, Blank(), [measure])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Bahneby , Try to create a measure like

if(calculate(distinctcount(category[category]), allselected()) >4, Blank(), [measure])

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.