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 ,

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 🙂