Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I want to show zero values in bar chart. Please find the sample data and the screenshot.
Answer text field is dimension and sector field is filter in the report..
Below is the measure I am using in Bar chart :
Thanks in advance
Solved! Go to Solution.
Hi @Kavya123 ,
Create a sector table, then create a relationship with the fact table and use it as axis.
Table 2 = DISTINCT('Table'[Sector])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kavya123 ,
Create a sector table, then create a relationship with the fact table and use it as axis.
Table 2 = DISTINCT('Table'[Sector])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kavia,
There is a simpeler solution to your problem.
When you create a measure for the number of students, for instance:
NumberOfStudents = COUNT(SP_DASHBOARD[STUDENTNUMBER])
, the 0-values are not shown in the charts.
When you create the measure like this:
@AllardBon I would consider that to be a bug - as it means that BLANK() is treated as being equal to 0 which is incorrect.
Usually you can achieve that by using fields from the dimension table and selecting "show items with no data"
Please show a sanitized version of your data model.