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

Hasham

Moving Product out allowed me to add in PY MTD and CY MTD in the value section. Here is the output

 

 

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

    Hi Anonymous !

    Now you can try to put only Day element from Date hierarchy as shown in earlier image. You can have Year & Month available as slicer value.

     

    Regards,

    Hasham