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

Hi FannyZ , 

 

I have created sample data with the same that you have explained. And I did use Show Items with No data, it is working. 

 

 

 

Could you check again and let me know.

 

Regards, 

Manikumar

 

FannyZ's avatar
FannyZ
Frequent Visitor
5 years ago

Thank you manikumar34 for your quick reply. I did check again, but it doesn't work. I'm also using slicers with this visual, could it be the cause ? If so, how can I counter it ?