Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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.
Hi @Deqmin ,
Sorting the date column by index should work.
Hi,
I did sort by Index, but still the output displayed show month year below 😞
Is there a way to help this?
Thank you so much for your help, problem solved.