Forum Discussion
Show all string/text data in Matrix environment
Hello everyone,
i have been struggling quite some time to show text/string data in a Matrix environment as there's a need for a pivot that has instead of numbers, text data.
As you can see from my print screens I can only show the first, the last but nothing in between and unfortunately as I am working on Analysis Services I can't play with any power query, only dax..
Any ideas?
Thnx in advance
8 Replies
Anonymous
There are only 2 rows in the sample, so I don't see what do you mean by between. The first and last only appear in the row total, both description data already shown in the matrix, PGK=10 and PGK=25, you only have one row because the item number is the same.
If you turn off the subtotals you get:
If that doesn't help, please provide a sample with a few more rows, and show us the expected output.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.