Forum Discussion
ReadTheIron
Helper III
2 years agoOrder x axis chronologically in column chart (manually created hierarchy)
I want to view my data by month, but I have a DirectQuery connection that won't automatically provide a date hierarchy. I created one manually following the instructions here: Solved: Date Hierarchy in Direct Query - Microsoft Fabric Community
However, now my data is displaying like this:
How do I get the dates to display in chronological order rather than largest to smallest based on Count of Work Order?
1 Reply
- lbendlin
Super User
click the ellipsis (...) in the top right corner of the visual, then sort by date. You'll have to do it twice as the initial sort order will be descending.