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
Use the forked arrows drilldown icon instead of the parallel arrows drilldown icon.
When using the forked arrow for drilldown it skips month and only shows days where data was actually collected. using the paralell arrows is the only way to get it to drill through the date hierarchy correctly. year-quarter-month-day. it displays the yearly data correctly 2019 then 2020 but as soon as you drop to quarter it sorts numericaly 1-2-3-4 when it should be 2-3-4-1 to keep the timeline in order, the same goes form months, its sorting jan-nov-dec instead of nov-dec-january. its like it forgets the year exists as soon as it drills below that level.
You could try creating a sort by column that includes the year and then the quarter name. You also might changing your axis from categorical to continuous or vice versa perhaps. Hard to replicate what you are seeing without sample data. If a quarter or month has no data it won't display but often there are settings for this to include items with no data.
Yes, the year information is no longer available at that hierarchy level.
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
