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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I've been trying to use dynamic parameters to have dynamic dimensions in a matrix visual. It works with one parameter, but I want to add two to have to dynamic hierarchy levels. I've recreated the steps from this tutorial https://www.youtube.com/watch?v=c1mezIySFf8 - added a parameter, added a custom column with values based on a parameter's value, created a column with all possible values and binded it to the parameter - and it works, but only with one. When I try to recreate the same steps for a second parameter (aka second custom column in my table, another manually eneterd table with parameter values binded to the parameter etc), it doesn't work. Moreover, the first parameter created stops working as well! What am I doing wrong?
PS: I've tried to make it work with the combination of selectedvalue, dynamic measures and bookmarks, but it makes the report too slow, so I'm trying to make it work with dynamic parameters hoping to optimize the speed.
Hi, @Anonymous
Can you share the parameter and custom columns that you created? We need to understand your specific problem in order to help you.
Parameter: Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
Best Regards
Janey Guo
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 123 | |
| 108 | |
| 44 | |
| 32 | |
| 26 |