Forum Discussion

alexflo188's avatar
alexflo188
Regular Visitor
2 years ago

Parameter and dynamic filter in the filter panel

Hello Fabric Community, 

 

I hope you're doing well, 

 

I'm trying to create a mesaure that I can put in my filter pannel to keep only the "1" that are returned in a field parameter that I put in a slicer. The thing is that I want the mesure to be dynamique as I change the field in the slicer. I tried this mesure: 

 

DynamicFilterMeasure =

VAR SelectedField = SELECTEDVALUE(Alarm_switcher[Alarm_switcher])

 

RETURN

 

SWITCH(

TRUE(),

SelectedField = "Watchdog alarms", [SUM_Watchdog_alex],

SelectedField = "PTRI alarms", [SUM_Kiwee],

SelectedField = "PMEI", [_Count_PM_Failure_New_model],

SelectedField = "Stolen Cable", [SUM_Cut_cable],

SelectedField = "PTI CHAdeMo", [FLAG_Station_cable_CHAdeMO],

SelectedField = "PTI SAE COMBO", [FLAG_Station_cable_SAE_Combo], BLANK() )

 

but I have am error message like this

Can I anyone could help me with any suggestion, 

 

Need Help

3 Replies

    • alexflo188's avatar
      alexflo188
      Regular Visitor
      2 years ago

      parry2k it's not quite it. What I want is to find a way to make a filter dynamic in the filter panel as I change my my selection on my parameter. That filed will have an action of contains = 1 so whichever field I choose in the parameter slicer than the visuel will only show me the data that has 1 in the visual.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    2 years ago

    alexflo188 still not fully sure what you are trying to achieve. It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.