Topn Year Slicer

[ROCKYDO12]

I created a topn single value fiscal year slicer. The goal was to show all fiscal years less then or equal to the number value entered in the slicer. So if 2 was selected it would show 2023 and 2022. I did this by creating a parameter and then creating a calcuation to use as a filter on each of my visuals. It was working perfect for all charts until I tried to apply to a matrix chart. When I add Fiscal year to the columns and add text in the rows it shows for all fiscal years rather then the slicer. It only does this for that one instense and i can't make sense of this. Is there any way to fix this?

https://drive.google.com/file/d/14Nx3AHoOBk_106QN8zCgQAStfZzarghd/view?usp=sharing

[v-jayw-msft · Accepted solution]

Hi @ROCKYDO12 ,

Change the relationship to "Both" and the problem will be solved.

Best Regards,

Jay

[ROCKYDO12]

I don't have a relationship set up but as soon as I set it up with calendar between fy rank it only closers for single year