Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |