Forum Discussion

Helper III

4 years ago

Solved

Show zero values in bar chart

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

Need Help

V-lianl-msft
4 years ago
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.

kkanukurthi

Helper III

1 year ago

Hi V-lianl-msft ,

Im looking for similar kind of requirement above. Tha bar chart should display "0" even if we dont have blank values in fields instead of fields missing when filter. I am aware of "show items with no data". This is something which i can see categories on y-axis with not displaying "0". Im looking for categories should display "0" when we filter on other columns.

Expected Output: