Order legend in line graph

[Anonymous]

Hi!

I have a line graph with a dynamic legend. How do I order the legend?

Same question for a matrix btw.

It looks like this:

And I have a table that kind of looks like this:

But I want the line graph ordered by month on the x-axis of course.

[v-chuncz-msft · Accepted solution]

@Anonymous,

Given the sample data, you may take advantage of Id column.

[BraneyBI]

 Create a calculated column in the same table as your Value field, which has the appropriate sort order - call it ValueSort

Then apply "Sort by columns" (from the modeling ribbon)  to the Value column using the ValueSort column.

When you use the Value column in your visual, it will now be properly sorted.