Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional display the chart

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

 

 

  • HI Anonymous

     

    You could add an IF function to your calculation.  

     

    Something like

     

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

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    HI Anonymous

     

    You could add an IF function to your calculation.  

     

    Something like

     

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