Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Dear community,
I have a lot of switches within my reports, which all have the same structure, but with one different filter within all expressions (f.e. calculate(sum), metric = "Revenue" / "New Orders").
Is there any possibility to set the filter before the beginning of the switch code, or do I have to write the calculate formular in every expression of my switch?
I am looking for somethin like this:
Filter(
Switch formular
), metric = "Revenue")
Solved! Go to Solution.
@lukmtb08 , Are you looking for a measure slicer ?
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@lukmtb08 , Are you looking for a measure slicer ?
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
7 | |
4 | |
3 |