Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Dear All,
I am facing an issue with a matrix visual coming from one pivot table wherein I have 3 slicers coming from another pivot table.
My requirement is that the matrix should show only those columns which are selected in those slicers. But still the matrix visual remains static without getting filtered once I select something from the slicers.
A many-to-many relationship was auto detected between those columns. To avoid many to many relationships, I created a bridge table and linked this bridge table with other two tables via a many-to-one relationship with cross-filter direction as single. I tried by setting it to both also.
Neither of the above suggested approaches didn't work.
Please suggest if there is an alternative to fix this issue.
Regards,
Saichandar.
@Anonymous Please Reffer Below Link I hope this helps you!THANK YOU!!
topics field parameters : Fields Parameter in Action I Practical Examples - YouTube
Dear Mahesh,
Thank you for your inputs, but this unfortunately didn't work. Since all the tables I have are pivot tables with column names as Attribute, Atrribute1, Value, Value1 and so on..
I actually tried and the matrix visual blanks out if I select anything from the field parameter slicer. Is there something to do with the relationships between the parameters? I tried establishing relationships but it didn't work.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
87 | |
66 | |
52 | |
45 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |