How to display by month year (e.g. March 2018) in sankey and with correct monthly sequence order

[Deqmin]

Hi,

I'm having difficulty to show data Oct 2018 - Oct 2019 by display month year on Sankey chart with right sequence.

Currently it mix with Oct 2018 and Oct 2019 and the month sequence order is mix, i wish it to display according the month and year in chart.

Please help, thanks.

[amitchandak · Accepted solution]

Create a sort month column.

sortMonth = format(date,"YYYYMM")

In Model, view make it as the sort column for Month year column

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Deqmin]

Hi Amit,

Is it possible to make Sankey show correct sequence follow by Index? Currently it show random month, i wish it to show Month 2018 then Month 2019 from top to bottom. Please help, Thanks.

 

[v-frfei-msft]

Hi @Deqmin ,

Sorting the date column by index should work.

[Deqmin]

Hi,

I did sort by Index, but still the output displayed show month year below 😞 

Is there a way to help this? 

[Deqmin]

Thank you so much for your help, problem solved.