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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
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.

  • AllardBon's avatar
    AllardBon
    Advocate I
    2 years ago

    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:

    NumberOfStudents = IF(COUNT(SP_DASHBOARD[STUDENTNUMBER])=0, 0, COUNT(SP_DASHBOARD[STUDENTNUMBER]))
    , the 0-values are shown in the charts.
    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      AllardBon   I would consider that to be a bug - as it means that BLANK() is treated as being equal to 0 which is incorrect.

  • kkanukurthi's avatar
    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:

     

    Thanks in advance,

    KK

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      That's a bad UX. Have your users asked for that?

      • kkanukurthi's avatar
        kkanukurthi
        Helper III
        1 year ago

        Yes lbendlin since i hide x-axis values and enable data labels users want to see '0' display for categories which have no data on bar chart. 

        Another request please, can we lock slicer drop down list on top screen instead of using scroll bars down the way to check category. It is occupying more space overlapping with other visuals.

         

        Thanks in advance

        KK