Power BI - How to show custom message in the chart when there is no data

[PBI_V2]

Hello All,

We have a requirement to show a custom message over the chart if there is no data for the charts to display. E.g.

When SalesAmt is 0 for all the records then Chart should display some message. Our Customer do not want to show blank chart in case there is not there for a specific criteria:

Kindly suggest how to resolve the issue.

Thanks,

PBI V2

[Ritaf1983 · Accepted solution]

Hi @PBI_V2 You can use dax measure for the message like :

Zero_Mwssage = if([Total QTY]=0,"The value is 0" , "")

And put it on the card.

The card is blank when the value is not 0 , so you can put it on any visual that you want

I attached the file file the example

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[PBI_V2]

Hello @Ritaf1983 

Thanks for your solution. With this , we are able to show custom message.

Thanks,

PBI V2

[Ritaf1983]

@PBI_V2 
Glad to help 🙂