Forum Discussion
Date column order
Hi All,
I have one date column I am trying to format that in order but it is not working.
I have created one month number column and sort it and year column also I have created and sorted it. I can see correct sorted order in data tab but not in visualization.
After 2020 I am expecting 2021 jan and so on. I am trying same thing in table visual it is not working. Any ideas how to get it.
Hi Viswa1127 Here is a link that will solve your question. https://community.powerbi.com/t5/Desktop/Sort-Month-and-Year-in-Chronological-order/m-p/957680
You basically create a sort column and sort the Year-Month column with the newly created column.
1 Reply
Hi Viswa1127 Here is a link that will solve your question. https://community.powerbi.com/t5/Desktop/Sort-Month-and-Year-in-Chronological-order/m-p/957680
You basically create a sort column and sort the Year-Month column with the newly created column.