Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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

1 REPLY 1
v-janeyg-msft
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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.