Show Table with "No Data" text displayed if values are not available in Power BI Table visual

[ashuaswinireddy]

Hello,

I have a table with no data in the table currently. I would like to show "No Data" if data is not available in the table. I do not have any filters for this table.

Can you please let me know how to show "No Data" if table is empty and without filters.

Thank you!

[Anonymous · Accepted solution]

Hi  @ashuaswinireddy ,

I created some data:

Table1：

Here are the steps you can follow：

1. Create measure.

isempty =
var _if=
ISEMPTY (
    CALCULATETABLE (
        'Table1',
        'Table1'[Group]
    )
)
return
IF(
    _if=TRUE(),"No Data","Data")

2. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@ashuaswinireddy , follow this approch

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

but here you need check for measure like

countrows(Table)

based on above measure change color etc