100% stacked bar graph and visual level filters

[Anonymous]

Hi there,

Here is a sample of my dataset, and its respective graph:

I have a various slicers for different demographics for users to slice the data by. In order to maintain privacy and confidentiality, if the sample size gets sliced down to less than 20 at any of the time points, I don't want the data at that time point to appear. (Note: different time points have different sample sizes)

I have tried using several visual level filters in combination with measures on the stacked 100% bar graph, however instead of filtering out the entire bar/time point, it filters by each individual segment in the graph, which skews the percentages and is not what I want.

Does anyone know how to filter a stacked 100% bar graph to remove the entire bar, rather than the segments within it? Or any work arounds using measures or columns? 

Thanks

[parry2k]

@Anonymous the measure you are using, should return blank() value when your data points are less than 20. You need to enhance your measure used in chart.

[Anonymous]

I am not using a measure in my chart, I am using a column. I tried to create a duplicate column with this code to do make the value blank if the column is less than 20, but it doesn't seem to be working: if(count('Year 4 data'[variable1]) > 20, 'Year 4 data'[variable1], BLANK())

I also created this measure: if(COUNT('Year 4 data'[variable1]) > 20, 1, 0)

and set it as a visual level filter to "show items when the value is 1" but then it only removes certain segments of the bar not the entire bar as I mentioned.

Any ideas?

[parry2k]

@Anonymous please share sample data or pbix file to work on it.