Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
alexflo188
Regular Visitor

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

alexflo188_0-1726583689468.png

Can I anyone could help me with any suggestion, 

 

3 REPLIES 3
parry2k
Super User
Super User

@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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@alexflo188 you can easily use field parameters to achieve this, check it out here https://youtu.be/xjBVKLn5fzs



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@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.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors