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
Jane689
Helper I
Helper I

Dynamic matrix column based on dropdown value

Hello,

 

I have 2 dropdowns called MENU 1 and MENU 2 , both created using column pagename

 

Now i have to create a matrix where MENU1 and MENU2 should be columns and count of visits, count of visitors, count of downloads should be values.

 

The challenge here is if i select some value in dropdown MENU1 and dropdown MENU2, then same should reflect in matrix column and count of visits, count of visitors, count of downloads should be updated accordingly based on my dropdown values selection

1 REPLY 1
v-yalanwu-msft
Community Support
Community Support

Hi, @Jane689 ;

Can you share your model scene and the results you want to output? By your description, I am a little confused.

can you provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Solved: How to upload PBI in Community - Microsoft Power BI Community


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.