Conditional display the chart

[Anonymous]

Hi everyone,

I have a table that shows the revenue for each product.

Then I draw a chart shows the percentage each product accounts for in total revenue (I chose "Percent of grand total" in the value area).

However, because there are products account for a very low percentage (for example lower than 1%). I am finding a way to hide them in the chart.

Thank you

[Phil_Seamark · Accepted solution]

HI @Anonymous

You could add an IF function to your calculation.  

Something like

IF ( <dax expression> <= 1 , BLANK() , <dax expression>)