Forum Discussion

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Single BAR Graph for Comparing Previous Year each months V/s Current Year Each Months

Hi Team  I want to create a bar chart were i have do comparison Previous Year Months Vs Current Year months in same Bar graph, able to create two separate graphs as below, But unable to creat...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Musadev's avatar
    Musadev
    2 years ago

    harirao 

    Check the results in the screenshot below and the PBIX file in the shared link.
    Link:  File.pbix 

    If you get your complete solution, please mark it as solution, so it will help others to find the solution. 

     

Musadev's avatar
Musadev
Icon for Resolver III rankResolver III
2 years ago

Hi harirao 
Please mark as Solution all the replies relevant to your multiple answers. This will really help all new members to get solutions to one question.

Add a tooltip page and add 2 cards to it. 
One for the current month-year and the other for the Last month-year
Link the visual with your Tooltip page and the results will be like shown in the image. 
DAX Script for the Last year.

 

Mon LY = SAMEPERIODLASTYEAR(TBL1[Month])

 

 

Good Luck with your learning journey. 

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi Musadev,

Can you please share me the sample PBIX file, as i tried above logic, not getting correct result as mentioned.

Thank you

 

Regards,
Hari