Forum Discussion
How to avoid blank pie chart when no values are available
Hello,
I have a calculated measure, which I have set as value in a pie chart. When the measure is 0, the pie chart visualization is empty. For column charts I get at least the value names. How can I avoid getting a blank visualization?
I have tried to make use of a card with a warning which is created by a measure, but I have to use it multiple times for different calculated measures. In order to avoid creating multiple warnings with the appropriate IF-condition as a filter, I have tried to make use of one filter
I.e.:
WarningMeasure = "You do not have any values for this visualization!" (and then set the visualization to Show items when the value is 0)
instead of
WarningMeasure1 = IF([CalculatedMeasure1] = 0, "You do not have any values for this visualization!", "")
WarningMeasure2 = IF([CalculatedMeasure2] = 0, "You do not have any values for this visualization!", "")
WarningMeasure3 = IF([CalculatedMeasure3] = 0, "You do not have any values for this visualization!", "")
etc.
and set the calculated measure as the visualization filter. But I cannot set this visualization filter since it is not selectable.
Any hints and alternative solutions will be appreciated!
xuri
Hi Xuri,
You can get the value names from a pie chart too. Turn on "legend" in the "Format" pane. You also can rename the title.
Best Regards!
Dale
2 Replies
- v-jiascu-msft
Microsoft Employee
Hi Xuri,
You can get the value names from a pie chart too. Turn on "legend" in the "Format" pane. You also can rename the title.
Best Regards!
Dale
- xuriFrequent Visitor
v-jiascu-msft
Thanks a lot!