Forum Discussion

Thom_'s avatar
Thom_
Frequent Visitor
4 years ago
Solved

Field Parameters - Individual Filters

Hi all!!   I have been using the field parameters feature (successfully I think) and now have a different issue that I'm wondering if it can be done. I will explain a simplified version of what I h...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Thom_ ;

    Sorry for the late recovery.

    You could change it.

    filter2 = SWITCH(MAX(Parameter2[Parameter2]),"Fl1", IF( [Fl1]="Y",1),"Fl2", IF( [Fl2]="Y",1),"Fl3", IF([Fl3]="Y",1))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Thom_ ;

Sorry for the late recovery.

You could change it.

filter2 = SWITCH(MAX(Parameter2[Parameter2]),"Fl1", IF( [Fl1]="Y",1),"Fl2", IF( [Fl2]="Y",1),"Fl3", IF([Fl3]="Y",1))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Thom_'s avatar
    Thom_
    Frequent Visitor
    4 years ago

    Hi v-yalanwu-msft ,

     

    Thank you so much for this!! It works and I have accepted it as a solution 😄