Forum Discussion
Anonymous
8 years agoNot applicable
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_SeamarkMicrosoft Employee
HI Anonymous
You could add an IF function to your calculation.
Something like
IF ( <dax expression> <= 1 , BLANK() , <dax expression>)