Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicer selection filter date

Hi Team,   I have Markets slicer like Apac, EMA , while selecting slicer --> I need Apac it show 2015 and 2016 year, if EMA then show all date.   Thanks, Kali
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    According to your description, I suggest you create a flag measure:

     

    Flag = SWITCH(SELECTEDVALUE('Table'[Market]),"Apac",IF(YEAR(MAX('Table'[Date])) in {2015,2016},1),"EMA",1)

     

    And then apply it to visual-filter pane ,set as "is 1" , the final output is shown below:

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

According to your description, I suggest you create a flag measure:

 

Flag = SWITCH(SELECTEDVALUE('Table'[Market]),"Apac",IF(YEAR(MAX('Table'[Date])) in {2015,2016},1),"EMA",1)

 

And then apply it to visual-filter pane ,set as "is 1" , the final output is shown below:

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