Forum Discussion

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
2 years ago

Order 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

  • 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.