Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create a multi year slicer?

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
Need Help

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes that is correct.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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])
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.