Forum Discussion

Kavya123's avatar
Kavya123
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's avatar
    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.

lbendlin's avatar
lbendlin
Super User
4 years ago

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.