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

Hi harirao 

Please check the following steps. I have used dummy data, for the first year your data will be blank. and after one year you can compare the bars/values.
I have added additional SID column to add up all the rows and get the value for the month. 

 

I created a measure to sum the value. here is the DAX code

Sum of Values = 
SUMX(TBL1,
TBL1[Value]
)

After that, I checked the data in a visual and it is coming as you have shown. 

Now i have added another Measure to get the amount of Value for the month of last year. 

Sum of Values LY = 
CALCULATE( [Sum of Values],
SAMEPERIODLASTYEAR(TBL1[Month])
)

i have added a stacked column Chart to the report pane. and also check the data in the table view below as well. 

 

If you are still have issues then share the PBIX file with masked data and i will validate it. Thanks