How to create a multi year slicer?

[Anonymous]

Hello 

Here is the problem MY23 data is showing up with the below DAX Query but MY22 data is not showing up.

Current Market Year = IF('Market Year Dates'[Current Month]>=10,'Market Year Dates'[Current Year]+1,'Market Year Dates'[Current Year]) 

I am not quiet sure why please let me know why only one is showing at a time. 

Thank you

[Anonymous]

Hi @Anonymous ,

I think you need to select "None" on MY22 Card visual to remove the filter from Slicer1. In my Sample, I can reproduce your issue. Here I use "Filter" on MY22 Card visual.

If I select "None" on MY22 Card visual, it works.

For reference: Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

It looks like the Market Year runs from October to September.  Am i correct?  Share the download link of the PBI file.

[Anonymous]

Hello Ashish,

Yes that is correct. I am looking for a dax logic to allow access to MY22, MY23 and so on. Right now with my current logic I am only able to see 1 year of data. 

Current MY  = IF('Market Year Dates'[Current Month]>=10,'Market Year Dates'[Current Year]+1,'Market Year Dates'[Current Year])

[Ashish_Mathur]

As requested earlier, share the download link of the PBI file.

[Anonymous]

Yes that is correct.