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

I'm I missing something per your instructions. How can I send you my PBIX. Demo Data?

 

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

    Hi Anonymous !

    You are almost there, now in your axis date has 4 element, Year, Quarter, Month & Day. Remove (Just click in [x] icon next to) Year, Quarter & Month, you will be left with Day element. This will let you analyze the CY vs PY sales at day level.

     

    Regards,

    Hasham