Forum Discussion
Mathew101
8 years agoAdvocate II
Line Chart two Axiz
Hi All, Can anyone point me in the right direction, how to you get a line chart with 2 axis. I want to plot amounts by date, now sales and units. Now I can do this with the Combo-Chart, howe...
Mathew101
8 years agoAdvocate II
Hi Lydia,
Like this in Excel: -
Thank you for the links I've up voted and commented
vishal17081990
8 years agoHelper I
Hi @Mathew101
You can do it with putting your Year column in Legand field.
Attached is PBIX for your reference.
https://1drv.ms/u/s!AoKR2AuKbWtQg0shNXVAPdFUYb_o
Hope this helps...
Regards,
Vishal.
- Mathew1018 years agoAdvocate II
Thanks for the reply Vishal, but we want the full timeline on the X - Axis and month-Year values for Sales amount on the left Y-axis and units on the right Y-axis