cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manu_cosmos Frequent Visitor
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: [Chart Card] with no data; how to display "No Record" while selecting another [drop do

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. Smiley Happy

 

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

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: [Chart Card] with no data; how to display "No Record" while selecting another [drop do

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. Smiley Happy

 

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

jagannath Visitor
Visitor

Re: [Chart Card] with no data; how to display "No Record" while selecting another [drop do

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