How to avoid blank pie chart when no values are available

[xuri]

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

[v-jiascu-msft · Accepted solution]

@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

[xuri]

@v-jiascu-msft

Thanks a lot!