Forum Discussion
Dynamically Change Matrix Rows Based on Slicer Selection in Power BI from Multiple tables
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
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.
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
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.