Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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 , 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")
Hello @amitchandak thank you for this. It worked for few widgets. Thanks again.