Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding two dynamic parameters to the table doesn't work

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

Community Support
Community Support

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

Helpful resources

Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!