How to create measures to display "no data available" in the widgets.

[Anonymous]

Hi, I am new to power bi and i wanted to create measures to show "no data available" message in my report. Please find the below pictures for refrence. The table i want to create measure in is using 2 data columns, one is "status" and other one is "total". So i wanted a measure for this table to show "no data available" whenever the data is null/empty.

This is the widget where i wanted to create the measure

These are the data columns that being used for this widget.

[amitchandak]

@Anonymous , refer if these can help

https://radacad.com/showing-an-alternate-text-when-no-data-available-in-a-power-bi-chart-visuals

https://powerbidocs.com/2020/11/25/displaying-a-text-message-when-no-data-exist-in-power-bi-visual/

[Anonymous]

Hi @amitchandak tried these but didnt work.

[amitchandak]

@Anonymous , I moved a text box behind with measure used in background of table

The measure used in conditional formatting of the background using the field value option

Color Net = if(ISBLANK([Net]), "#FFFFFF00", "#FFFFFF")

[Anonymous]

Hello @amitchandak thank you for this. It worked for few widgets. Thanks again.