Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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,
@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.
@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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.