Forum Discussion
How to Display Matrix Visuals with Related Dimension Text Values
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! 🤠
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! 🤠