Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Line Chart with 2 lines & Measures

Hi, 

 

i have 2 measures, [Sale MTD] & [Sale MTD LastYear]


I want to show the 2 lines in a line visual. How can i achieve that?

I enclosed  a pic for reference.

 

In excel it looks easy. but i couldn't achieve the same in PBI.

 

Thank you in advance 

Need Help
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Hi Anonymous !
    You should be able to achieve this by draggin both Sales in the Y-Axis and Date in the X-Axis. Note that if you add a Legend yo the visual, you wont be able to add more than one field to the Y-Axis.

    Let me know if that helps!

2 Replies

  • PabloDeheza's avatar
    PabloDeheza
    Solution Sage
    3 years ago

    Hi Anonymous !
    You should be able to achieve this by draggin both Sales in the Y-Axis and Date in the X-Axis. Note that if you add a Legend yo the visual, you wont be able to add more than one field to the Y-Axis.

    Let me know if that helps!