Suppress Individual Categories Based on Total

[AshG1990]

Hi all,

I'm new to the community so apologies if this has already been answered, I have done a search but can't find quite what I'm looking for.

My query is, how can I suppress/hide all categories in a Bar/Column chart if the total of those categories falls below a certain number? It must account for any filters/cross filtering etc...

Please see screen print of the chart I'm trying to do this on.

Thank you in advance, any help would be much appreciated.

Ash

[amitchandak]

@AshG1990 , Create a measure like , assume you are using measure M1 in value

M1 subotal= calculate([M1], removefilters(Table[Value])

Now use this in the visual level filter to control the values

refer if needed

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

[AshG1990]

Hi @amitchandak,

Thank you very much for the reply, I have tried this and it worked perfectly.

However, there was one thing I didn't mention, I may have nulls/blanks/non-scored values in the response field which should not be included in the total. I have tried messing around with the REMOVEFILTERS with another FILTER but it seems to be causing it to mess up.

Do you have any advice on this?

Thank you,

Ash