This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I currently have a dynamic measure that works that I can use a slicer to update the value/measure. An example, being, I have measures created to compute "Rate", "Last 7 Rate", and "MTD Rate".
And my Dynamic measure looks like the below:
Dynamic Measure =
SWITCH (
VALUES ( 'Measures List'[Measure Name] ),
"Rate", [Rate],
"Last 7 Rate", [Last 7 Rate],
"MTD Rate", [MTD Rate]
)
But I would like to try and modify this where I can I list out multple Measures in a Table/Grid. I also have measures for things like "Qty", "Last 7 Qty", "MTD Qty"
Do I need to make a Dynamic Measure for Qty and others and then somehow connect them to another measure/slicer that lists "Last 7", "MTD", etc?
So the hope is that I can include columns in table/grid for Rate | Qty | and others. And via a slicer chose "Last 7", "MTD", etc. and have each column update.
Solved! Go to Solution.
@ptmuldoon , You can use field parameters and select multiple as per need
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
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw
@ptmuldoon , You can use field parameters and select multiple as per need
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
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 34 | |
| 26 | |
| 25 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 65 | |
| 35 | |
| 32 | |
| 25 | |
| 23 |