Forum Discussion

xuri's avatar
xuri
Frequent Visitor
9 years ago
Solved

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

  • 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's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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