Chart order by last 12 Month: Start to end

[mohittimpus]

Hello,

I'm showing the last 12 months( last month is May 2020 ) data but I'm unable to show order like from start to end (June to May)

See the graph : (There is no data for some months so it's ok if some months are not in the graph)

So actual graph order: September, November, May, July, January, December, April

What I want: July, September, November, December, January, April, May

What I already did till for order :

1.Try to change the sort by rank column but got this error :

2.Also, I can show perfect order if I add the year from Date Hierarchy but its add year in the axis which I don't want like this: May 2020

I attach a file please take a look:  testFile.pbix  

Thanks In advance

[dedelman_clng · Accepted solution]

Hi @mohittimpus -

First, use "month" from the Date table, not the Sales table

Second, you can put RankRange in the Tooltip field for that visual, then sort by Rank Range using the 3-dots in the corner of the header.

Hope this helps

David

[mohittimpus]

Thank you so much. it works and I choose an only nonblank value in the filter so I Get What I want.