Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a pie chart, when the value is coming zero during the selection it is showing a message "The chart is not displayed because it contains only negative or zero value" as shown in below image
I want to populate any custom message at the place of default message, Is it possible if Yes please let me know the steps.
Thanks in advance
Hi,
Maybe this trick:
In the chart properties, in Data Handling Section, Calculation Condition, using expression =RowNo()>0 and then in Message, enter the desired one
Kind regards
Hi Thanks for your reply It doesn't work
Then, maybe
If A my measure (here in Master Item), then in the same menu and input box: [A]>=0 and a display message ?
Expounding on @mpc 's suggestion, you could use a condition along the lines of:
RangeMax(Aggr(YourExpressionHere,YourDimensionHere))>0