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
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
