Forum Discussion

FannyZ's avatar
FannyZ
Frequent Visitor
5 years ago
Solved

Stacked chart - Show all Y axis value

Hello everyone,   I have a stacked chart ofr which I'd like to show all possible values for the Y axis even when null.  I did do a right click on the Axis data and selected "Show items with no val...
Need Help
  • FannyZ's avatar
    FannyZ
    5 years ago

    Thank you for your follow up. I have just solved the problem by adding an extra table with all categories for each type of order in my report and then I created a measure with a filter on the type of order to avoid using the filter on the visual. That worked just fine 🙂 

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

FannyZ 

If that doesn't works , please create a calculated column or measure and use that. 

 

Use the below DAX to convert the blank cells to 0.

Column = IF(ISBLANK('Table'[Value]),0,'Table'[Value])
 
 

 

Please accept this as solution if works and leave a like. 

 

Regards, 

Manikumar

FannyZ's avatar
FannyZ
Frequent Visitor
5 years ago

Hello Manikumar,

 

I don't have any blank cells in the categories data.

Could I get those results because of the filters I'm using ? It does show category "=0" when there is 0 lines, but not the other ones..

 

 

Thank you,

 

  • manikumar34's avatar
    manikumar34
    Icon for Solution Sage rankSolution Sage
    5 years ago

    FannyZ ,

    Are you using the slicer which is on Y-Axis of the chart?? 

     

    If so it will  happen, to do not filter the data with the slicer on this chart stop interactions from View>Edit Interactions

     

    If possible can you share the slicer screenshot with the slicer and chart?

     

    If you think this is helpful please Accept as Solution and leave a like.

     

    Regards, 

    Manikunar

    • FannyZ's avatar
      FannyZ
      Frequent Visitor
      5 years ago

      Thank you for your follow up. I have just solved the problem by adding an extra table with all categories for each type of order in my report and then I created a measure with a filter on the type of order to avoid using the filter on the visual. That worked just fine 🙂