Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have three matrixes which I am trying to achieve, when a user select a row from first matrix and then second matrix I'd want to keep my selection from first matrix for my third matrix
My first matrix includes Category > Sub Category > Product Group
Second Matrix includes Brand ID
Third Matrix includes Product ID.
At the moment when I select a value from second matrix it overwrites selection of first one and in my third matrix it shows products which didn't belong my category selection from first matrix.
I tried to use VALUES and SELECTEDVALUE but couldn't find an answer.
please find attached my sample file
kind regards
Hi @jamuka ,
Such scenario may accor when the three matrix are created based on fields
1.from a same table
2. or from different tables but there are built relationships among them.
So you may need to create a new seperate table.
If you are still confused about it, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-eqin-msft
thank you for your answer, I shared my pbix file in my question. I created a seperated table but couldn't figure out how to proceed. I assume I shouldn't built relationship between tables and use measures for filtering.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |