Forum Discussion
Sorting X axis values
HI duncan3172
You could just use Sort by column in Power BI to get it.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Just add a year-quarter column in edit queries or data source
Then set sort by column for quarter column
and you could use the same logic for month column (Add a year-month column that [Year]*100+[Month])
Regards,
Lin
mwegner, so if i want it to work correctly i just have to tell it to filter out last year's data? simple enough
HI duncan3172
You could just use Sort by column in Power BI to get it.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
https://radacad.com/sort-by-column-in-power-bi
Just add a year-quarter column in edit queries or data source
Then set sort by column for quarter column
and you could use the same logic for month column (Add a year-month column that [Year]*100+[Month])
Regards,
Lin