Data segmentation

[DanielBispo]

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

[Anand24]

@DanielBispo ,
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 !!! LinkedIn