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 

Actually i dont have Quantity & Date column, only have Month & Values, by using this Data i have to create Previous Year Months Vs Current Year month Calender Year {NOV to OCT} i.e (Nov-22/Nov-23..........until Oct-23/Oct-24) in SAME BAR graph 



Thanks,
Hari

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

wait let me add your data to my data set. and I will update it, you can use the same records, so no worries

If you can share the sum of values DAX i will transform it for last year as well(If measure is used) else only sum of amount on the visual then i will use static values