Forum Discussion
Dynamically Change Matrix Rows Based on Slicer Selection in Power BI from Multiple tables
- 1 year ago
Hey danishrizvi
Thinking maybe Field Paramters could work.Here's a quick example I created and a link to a Microsoft resource page: Implement data translation using field parameters
- 1 year ago
I tried this approach, and it worked flawlessly. The solution is straightforward: I used a field parameter and added all the required columns to it. I renamed the field parameters based on the slicer I was using on the page. Then, I created a 1:* relationship between the field parameter and my slicer table to filter the data. I ensured this relationship was active so the values displayed correctly based on the slicer selection.
I used the field parameter in my rows, allowing the table's column to dynamically change based on the slicer selection.
Hi danishrizvi
please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And 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.