Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Filter on visual applying at the data slice level not overall level

Hi 

 

I've got a variable called D1b. It has 7 response options to it. I have it shown as a pie chart. If a person uses slicers and the total number of respondents (rows) gets down to less than 10, the visual needs to go blank. I'm trying to do this by using a filter on the visual using a variable called D1b count, where if the count is greater than or equal to 10, the visual shows. Problem is that the filter seems to be applying to each response option too. So, I might have a total of 28 responses after using my slicers, but I will have missing pie slices becuase that response group in D1b is less than 10,  but I want the whole visual, and to hide it only if the whole cohort is less than 10. i.e., i want small groups to show their slice as long as the overall group is greater than 10. here is my code: 

 

D1b count = CALCULATE(COUNTROWS('Demographics'), ALLSELECTED('Demographics'[D1b]))

 

 

here's what it should look like:

 

but say the group 1000+ FTE was only 5, not 10, then it would take that slice off the visual for some reason. 

 

Please help!

 

 

3 Replies