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

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