[Chart Card] with no data; how to display "No Record" while selecting another [drop down card]

[manu_cosmos]

Scenario:

1) Created a drop down card in dashboard

2) It is linked to another clustered bar chart

3) While selecting one item in drop down, it is getting reflected in bar chart

4) But, another item has no item associated to the barchart or it might be updated soon

5) So, the chart is displaying a blank space

6) The question is? can i display a "No Record found" message to that chart area

[jagannath]

We need to create two meaure

one measure reuturn the count "DataCount"  DataCount=count(Data)

Another measure returns the "No Record"  NoRecord=if(DataCount=0,"No data found","")

create a data card and keep the category label off and keep it over the bar chart

Another simple Idea is create a text box and with No Data found keep it beside the visual

[v-ljerr-msft · Accepted solution]

Hi @manu_cosmos,

I don't think there is an option to do it Power BI currently. You can add it as an idea on Power BI Ideas forum to improve Power BI on this feature. 

In addition, an alternative solution could be that create a new measure to return "No Record Found" text if the values on Chart is blank, then show the measure on a new Card visual, and put the Card visual above the Chart.

Regards