topic Re: Line Chart query in Developer

Line Chart query

Rakshya — Fri, 09 Mar 2018 03:19:49 GMT

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.

Re: Line Chart query

v-chuncz-msft — Wed, 14 Mar 2018 08:55:17 GMT

Rakshya,

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

Re: Line Chart query

Rakshya — Thu, 15 Mar 2018 00:12:00 GMT

Hi Sam-

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

Appreciate it.

Regards,

Rakshya