Hi! I have here two data segmentation visual that refers to a date. But one refers to 2022/23 and the other 2023/24. I want to make so, that when i filter on one of them, the other one filters the equivalent month automatically. For example, if i filter september 2023, i want the other data segmentation to filter september 2022 automatically, am i able to do this? i tried creating a column that equals the dates, like september 2023 = september 2022, and then relate those columns, but it just doesn't work.
My visuals looks like this
@Anonymous ,
Join both tables on Month. If not already present, create a calculated column for month anf then join on it.
Although one data is from 22/23 while other is from 23/24, the join will still happen since month name will be same in both(April = April, May = May, etc).
 |
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 133 | |
| 104 | |
| 61 | |
| 59 | |
| 55 |
