Forum Discussion

mterry's avatar
mterry
Helper V
6 years ago

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...
Need Help
Tips and Tricks
mterry's avatar
mterry
Helper V
6 years ago

I attempted to sort both the date column, and the month column by the period column (i.e. 201901) - when I attempt to do that with the date column, the diplay gives me an error. When I attempt to sort the month column by the period I get an error saying 'We can't sort the 'MonthName' column by 'Period'. There can't be more than one value in 'Period' for the same value in 'MonthName'.....

sevenhills's avatar
sevenhills
Super User
6 years ago

The error is caused because there are more than 1 values, in your case. 

             i.e., Display Column Values to Sort Column Values has to be 1-to-1 mapping.  
Data can be duplicated but strict 1-1 mapping.

 

Please check Periods - MonthName values ... or post the screenshot of the data

 

Month Periods (Display)      YYYYMM (Sort)

JAN 2019            201901

FEB 2019             201902

 

Date (Display)      YYYYMMDD (Sort)

01-Mar-2019      20190301

02-Mar-2019      20190302

 

- SV

 

  • mterry's avatar
    mterry
    Helper V
    6 years ago

    Okay, so these all seem to be work arounds, not necessarily addressing the original issue I had. If I use the date column (individual date) on the axis, and let Power BI use the date heirarchy, using only month, then there is no way to segregate the months across years without including the years value and drilling, correct?