Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
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.
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!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |