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. 

     

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

Hi Musadev 

Thank you for your assistance. After excluding blanks, it's working well.

I have another query regarding formatting. Is it possible to display both month names as "Nov-22" and "Nov-23" when tooltips are enabled? Additionally, could each month's names be shown next to each other like "Nov-22 || Nov-23"? This formatting would be helpful for presentations.



Thank you once again for your help and assistance.

Regards,
Hari

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

Hi Musadev 

It's possible to create a visualization as described above. If it is, could you please suggest the logic to develop it?

Thanks,

 

Thanks,
Hari

 

  • 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.