Stacked chart - Show all Y axis value

[FannyZ]

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! 

[manikumar34]

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

[manikumar34]

@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]

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]

@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 · Accepted solution]

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 🙂 

[FannyZ]

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 ?