How to get a certain visual representation using a measure

[amalrio]

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 into my original table, Is this even possible. I have seen text dilimitted by measures but I have less knowledge to do it. Hope you can help.

Below is my data and required output.

[amitchandak]

@amalrio , You have split the column Text into rows. https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Then take that on the row and year a column. Create a color measure 

Measure = countrows(Table)

color measure = if([Measure] >0, "Blue", "White")

Use this measure for both for font and background conditional formatting using "field value" option

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[amalrio]

@amitchandak ,

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  🙂

[Anonymous]

@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]

@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.