Forum Discussion
Solved
Sorting X axis values
Im a realitively new PBI user and now that we have rolled over into 2020 im having an issue with my date values on the X axis of a line plot. My plot is displaying the data for Q1 of this year be...
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
