Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating Line Chart in Power BI comparing Prior Year vs. Current Year by day

Good Day All I'm trying to create a line chart in PBI that shows PY vs. CY usage for a product by day of the month on the same line chart. Screen Shots below   Thank you in advance for your time. ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Hasham

    You are the man! Can believe we accomplished this via screen shost. In the future, can I send a demo PBIX. to make thing easier? If so, how would I go about it? I know I can use Dropbox or Google Drive, but not clear on every step to get it done.

    Much appreciate you help today.

     

    Thank you

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Hasham

Initially moving CY MTD to the visual that's where it landed in the Tooltips sectioin. Moving CY MTD to Values replaced PY MTD. Do you have any other suggestions?

Much appreciate your help!

 

 

HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous !

You can move Prodcut out of [Legend] to be able to compare, 2 or more KPI's in Line Chart. You can look for matrix or other visuals which will alow you to plot multiple values against category & axis.

 

Regards,

Hasham