Forum Discussion
htaunay
Microsoft Employee
Microsoft EmployeeSwitch X Axis column through a slicer filter
Hi PowerBI experts, I am currently working with a dataset where each line represents information of a specific hour, and would like to plot such data grouped by days, weeks or months, given the u...
Excellent solution OwenAuger, thanks! Just a question, how do you use the order column in your visuals afterwards?
OwenAuger
Super User
Super UserHi Anonymous
Are you asking about the Time Value Order column in my sample pbix file?
That column is used as the sort-by column for Time Value Text. Since Time Value Text contains a mixture of granularities (Date, DateTime, Month and Year in my case), it is impossible to sort this column based on its own values.
So Time Value Order is not directly used in any visuals, but set as the sort-by column for Time Value Text in Modeling = > Sort by Column. I also hid it in report view as the end user has no use for it.
Regards,
Owen
It's the Modeling -> Sort by column, thanks!