Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Re-order column and legend

How can I reorder my coloum chart and legend to go from Current, 30 days, 60 days, etc and up instead of the way it is right now? Please, help!

 

Thank you

 

legend
reorder

3 Replies

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    6 years ago

    Hello,

     

    Could you please clarify what exact visual do you mean?

     

    Kind Regards,

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It's a line chart visualization. 

      My data is set up as

      Date             Value

      1/1/2019        30

      2/1/2019        40

       

      I want my legend and data to be sorted based on a filter 

  • dm-p's avatar
    dm-p
    Super User
    6 years ago

    Hi Anonymous,

    You can create and apply a sort by column to your Status field. Sort values would be as follows (or similar):

    1. Current
    2. 30 Days
    3. 60 Days
    4. 90 Days
    5. 120 Days
    6. 150 Days
    7. Over 150 Days

    Once the column is set up and assigned to your Status column, then sorting your chart by this column will put it in the order you expect.

    Good luck!

    Daniel