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 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.
4 Replies
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesAs 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.
