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 t...
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Anonymous

     

    You could add an IF function to your calculation.  

     

    Something like

     

    IF ( <dax expression> <= 1 , BLANK() , <dax expression>)
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Anonymous

 

You could add an IF function to your calculation.  

 

Something like

 

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