Forum Discussion
How 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...
As I mentioned in there, I do not want to add any further columns into the model, there should be a way to split a cell using DAX measure, I am thinking of SWITCH but have not got enough technical knowladge 🙂
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.
Anonymous ,
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.