How do I scale bar chart to last 12 months ONLY

[YG]

Hi All,

I have read few articles on this issue and I have manged to implement some if it and so far non of them seems to work as I would Like, Field in questions is : [Event_date.autoCalendar.YearMonth]

This is what I see: when I implement and expression field  =[Event_date.autoCalendar.YearMonth] 

So based on articles I changes my expression to:  =If([Event_date.autoCalendar.YearMonth] >= '2022-02', [Event_date.autoCalendar.YearMonth])

Seems like it worked but on the right corner bar is NOT intended to appear is appearing which makes no sense

I only want is this to be scaled like below ( Not solved just cut part of above)

The main issue because of this is when I try to do Storytelling option to presentation it only appear first months and I cant see the last months too. So far I tried,

Changing Y axis to scale - did not work

Sorting descending - Makes no sense to as doesn't go with other charts reading left to right

Anyone who can help would be really be appreciated. Thanks in advance 

[ogster1974 · Accepted solution]

In your yearmonth dimension you have the option defaulted to include null values.  Unticking this will get you the chart you want.

[YG]

Thanks @ogster1974 works like a charm.