compare 2 years in graph stacked barr

[Vanessa250919]

Hello all,

I need to have a graph with stacked barr for compare, example JAN2021 with JAN 2022 side by side, actuly a I can compare without scrooling to JAN 2022 . It's possible ? 

[v-chenwuz-msft]

Hi @Vanessa250919 ,

What you mean is to have the x-axis reordered so that JAN can be compared together.
If so, then you could try this renaming the x-axes so that they can be sorted.
I did this by creating a column based on the date column, using the formula below.

Rename X = FORMAT([Date],"mm mmm yyyy")

Then sort the x axis

result

Or you can try small multiples, adjust the rows and columns to achieve the result you want.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,

The easiest way to do this would be to have separate measures for this year's values and last year's values.

E.g. 
LY Sales = CALCULATE([Sales],SAMEPERIODLASTYEAR('Calendar'[Date]))

After you have this measure you can place both of the measures in a chart and you get the desired end result. 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!