Re-order column and legend

[Anonymous]

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

[dm-p]

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

[v-evelk]

Hello,

Could you please clarify what exact visual do you mean?

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

[Anonymous]

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