Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In your yearmonth dimension you have the option defaulted to include null values. Unticking this will get you the chart you want.
In your yearmonth dimension you have the option defaulted to include null values. Unticking this will get you the chart you want.
Thanks @ogster1974 works like a charm.