Line Chart query

[Rakshya]

 Hi -

Can anyone help on my below requirement? Bit urgent.

I need line charts for Total Sales  compared across Store, Area Manager, States in the same visualization . Can we do that?

Line chart has Axis with Retail month.  Here below is something I did but I want the lines to be seen separately for Store and AM likewise for State and Country. All are using same measure Total sales created using DAX query.

[v-chuncz-msft]

@Rakshya,

Check if you may select Unpivot Columns in Query Editor, and then take advantage of the Legend field.

[Rakshya]

Hi Sam-

As this is also new to me so can u please be more detailed.

Appreciate it.

Regards,

Rakshya