Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I created a dax for sameperiod last year calculation. I put calculation in one chart and sameperiodlat year in Prev Chart. But i want to change X-Axis Values to show last year as well. Like 2019 instead of 2020. Is there any other way like using visual level filter where i change bottom chart to last year. For example when someone select Year-month 2020-08 on slicer the bottom chart give 2019-08.
In your Calendar table add a calculated column "Same day last year" and then use that as the x axis for the bottom chart.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |