Forum Discussion
amalrio
Helper V
5 years agoHow to get a certain visual representation using a measure
Hi Gurus, I have copied an image below, what I want is to create a measure to split the text column by comma(,) and show in a matrix visual like below. I do not want to enter new rows or columns...
Anonymous
5 years agoNot applicable
amalrio
You do not need to create a complex measure, matrix and 2 measure should do the trick using conditional format.
See attached sample pbix if needed.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
amalrio
Helper V
5 years agoAnonymous ,
My challange is to split the cell wich is comma seperated and show it it in a diffrent line in a matrix, wtihout making changes to the data table.