Order legend in line graph

[jppuam]

Hello,

i've a line and stacked chart, and i've a month field (value), and i'm connected to another table that as the id (number month) and the name of the month by text. 

But when i use that field its not formated the graph correctly.

 

Do you know why ?

thanks,

JR 

[v-yulgu-msft · Accepted solution]

Hi @jppuam,

Do you want to display the Month name on X-axis in correct order?

Since you have related two tables with month, in the second table, please choose the month field (text), and set its "Sort By" option to month number field.

Then, add MonthName from this table to bar chart.

Regards,

Yuliana Gu

[jppuam]

Thank you very much Yuliana