Forum Discussion
How to Display Matrix Visuals with Related Dimension Text Values
I've been working with matrix visuals and have encountered an issue with displaying data from related dimension tables such as names. I have been using a DAX function to get the desired result, but I wanted to know if there is a better solution that doesn't involve bi-directional filtering. Example:
Customer Dimension:
Parts Sales:
Table Relationships:
'Customers'[Customer_ID] 1:* 'Part Sales'[Customer_ID]
Table displays as desired:
However, a matrix requires a DAX measure to achieve the same result:
The DAX used is:
Please let me know if there is an easier solution to this without using bi-directional filtering if possible. Thank you!
since you are filtering by parts, ( it is on the row level of your visual ) ,and you are dragging customer name ( from dim customers ) to the values,
sales part doesnt filter dim customers table , and this is the reason of such behavior .
what you can do, is instead of putting the customer name into the values, you can drag it into the rows of the matrix also .
now in the table vsiual, it is working, because, customer name is used as a dimension and not as a value ( like First, Last , .... like in the matrix ) , and this is the reason why it is working in the table visual .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
1 Reply
since you are filtering by parts, ( it is on the row level of your visual ) ,and you are dragging customer name ( from dim customers ) to the values,
sales part doesnt filter dim customers table , and this is the reason of such behavior .
what you can do, is instead of putting the customer name into the values, you can drag it into the rows of the matrix also .
now in the table vsiual, it is working, because, customer name is used as a dimension and not as a value ( like First, Last , .... like in the matrix ) , and this is the reason why it is working in the table visual .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠