Hi,
I'm trying to create a dashboard of service user data which needs a functionlity to be able to filter by various characteristics (e.g gender, age group, neighbourhood etc) including combining those filters. However, end users shouldn't be able to filter down to small groups (<5) in order to prevent the data being viewed at a level where anonymity could be compromised. So with the Example Data , I'd want to be able to filter to see the data for females from east or west, but not south (while still having south available as a filter for the overall dashboard).
The core visualisations I'm using are averages of the service ratings and stacked bar charts of the breakdown of responses for each service rating.
What I've tried so far is:
A measure which counts the number of respondents and then using that measure to filter if <5.
Respondents = count('Response 2023'[Identifier])
Show_Hide = If(countrows(values('Response 2023'[Identifier]))<5,"Hide","Show"
With the first I applied the filter as show items when the value is greater than 5 and for the second show items when the value contains show. However both of these when applied to my breakdown charts hide the chart segments with <5 rather than filtering based on the overall (e.g for service 1 rating filtered by female it would hide the chart segments for how many people rated it 1, 4, or 5 as there are not 5 female service users giving those ratings, while leaving 2 and 3 - what I want is the whole chart visible when there are more the 5 service users overall and everything hidden otherwise). Additionally, this sort of measure filtering doesn't seem to be able to apply to all visualisations.
Any solution or even workable direction would be much appreciated!
