Forum Discussion
Sorting bar chart chronologically when using date hierarchy
I've seen a few posts on this, but nothing I could find to answer this specific concern. I have daily data from Dec-19 through Mar-20 that is in a bar chart. End users would like for it to be grouped...
amitchandak
Super User
Super UserAnonymous , if you are using date hierarchy than drill down should have given right sorting
We typically use date table and column-like
Month Year = FORMAT([Date],"mmm-yyyy")
or
Month Year = FORMAT([Date],"mmmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
And we mark month year sort as sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column