Line Chart with X axis as Multiple Columns

[Anonymous]

Hi everyone,

I have a dataset as follows. I need to plot line chart with three legends (for Digital, Hybrid, Traditional). X axis should be M1_PAY_CHANNEL, M2_PAY_CHANNEL,.....,M6_PAY_CHANNEL. Y axis should be count of each Digital, Hybrid and Traditional.  

For example, first data point is as follows,

X axis point is M1_PAY_CHANNEL, value

     for Digital chart is 7,

     for Hybrid chart is 0,

     for Traditional chart is 1

Could you please assist me in this regard? I herewith attach the PBIX File.

M1_PAY_CHANNEL	M2_PAY_CHANNEL	M3_PAY_CHANNEL	M4_PAY_CHANNEL	M5_PAY_CHANNEL	M6_PAY_CHANNEL
Digital	Digital	Digital	Digital	Digital	Digital
Digital
Digital
Digital	Digital	Digital	Digital	Digital	Digital
Traditional	Digital	Traditional	Traditional	Traditional
Digital	Digital	Digital		Digital	Digital
Digital	Digital	Digital	Digital	Digital	Digital
Digital		Hybrid		Hybrid

Thanks

[v-kkf-msft]

Hi @Anonymous ，

Please select all columns and unpivot in Power Query Editor.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

It worked. Thank you very much 🙂