Forum Discussion

rgdz's avatar
rgdz
Regular Visitor
3 years ago

Line and Cluster Column Chart Sort Column Legend

Hello: Power BI novice here. I have a line and cluster chart; the column legend refers to a column "Account Type Description" with a value of either Expense or Income. In a simple cluster chart, I can sort descending, but I can't find a way to change the order in a line and cluster chart. I want Income and then Expense, but the default is alphabetical.

 

Any help is much appreciated!

 

3 Replies

  • rgdz , I can still see option to sort legend in line clustered column chart ( I am using latest version of power bi)

     

     

    • rgdz's avatar
      rgdz
      Regular Visitor

      I appreciate your response. I do not see that option, and I am on the most current version of power bi desktop as well.

  • VincentS's avatar
    VincentS
    Regular Visitor

    The problem doesn't seem to be the version. The difference is that it doesn't show the sort option when is date in the x-axis. But it gives the sort option for non-date field.  

    Month-Year is a string: 

     

    Date field:

     

    I was also looking for an answer for this issue.