Line chart with Years, and Month for only current year

[Anonymous]

I want to do a line chart, where years between 2006 and 2020 are shown, no months. But for 2020 it would also show the months.

So the date axis would look like:

2006 2007 2008.... 2019 2020 Jan 2020 Feb 2020 March

Is there a way to do this? Or any custom visuals?

[seanguerrero]

As always, great solution @amitchandak. Any tips on sorting now? I now have 2019 2020 2021 2022Feb 2022Jan. ...or should I just create a separate sort table?

[amitchandak · Accepted solution]

@Anonymous 

You can create a new column in your date dimension like that and use

New column = If(year([Date] =year(today()), format([Date],"MMM YYYY"), format([date],"YYYY"))