Forum Discussion
Help Adding a Concatenated Column to Matrix Visualization that Ignores Slicers
Hello, I am working with data similar to the Sample Superstore. I’ve built a PBI matrix (attached) with several slicers, e.g., Sub-category, Product Name, etc. Please see the screenshot. I...
Hi,
Write this measure
Measure = CONCATENATEX(CALCULATETABLE(VALUES(Orders[Sub-Category]),ALLEXCEPT(Orders,Orders[Order ID],Orders[Order Date],Orders[Country/Region],Orders[Segment])),Orders[Sub-Category],", ")Hope this helps.
This does not work for my purposes, because as stated in the problem statement, the column must be to the left of the Sub-category and not all the way on the right. It has to be added as a row to the matrix, not as a value. But thank you so much for trying to help!
Hi nicanica07,
May I know if you raised this in the partners forum and if the issue has been resolved?
Thank you.
