Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |