Forum Discussion
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 value" but that doesn't change anything.
More concretly, this is what I want the Y axis to show:
>15days
<= 15 days
<= 10 days
<= 5 days
and this is what I get:
<= 15 days
<= 5 days
Because there is no data for the categories <= 10 days and >15days.
Any tips ?
Thank you!
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 🙂
6 Replies
- manikumar34
Solution Sage
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
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 ?
- manikumar34
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
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,
