Bar graph showing data by quarters for the current year and then only by years.

[jtemes]

I have a maturity profile chart that shows amounts on a yearly basis, however, I would like, for the same year as the date filtered, to show the amounts by quarter. The idea is to get something like this. 

Thank you all for your help

[amitchandak]

@jtemes , Create a new column in your date table like and use that in visual

Display = if(year(today()) = Year([Date]) , "TRIM " &format([Date], "Q YYYY"), format([Date],"YYYY"))

Sort the above on

Display Sort = if(year(today()) = Year([Date]) , year([DAte])*100 + quarter([Date]), year([DAte])*100)

[jtemes]

I am struggling in sorting the Display column. Can you please help on how to do this?