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 
You can add the month-year into the tooltip however on the same visual i need to check it first and then i will update you here. 

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

Hi Musadev 

Thank you I will be waiting for your response, In the meantime, I attempted to add the Month-Year into the tooltip, but it seems to be displaying only previous months. 

Regards,
Hari Krishna 

  • 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