Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |