Forum Discussion
Possible to sort cells?
Hello everyone i want powerBi to automatically sort something within a cell. Is this even possible? Because, I found nothing regarding cells in PowerBI so far on the internet. Anyhow my problem is...
Well, you could get there via DAX but it would be fairly nasty. You would need to create a column for each of your 10 things. You would use a formula like the following for each:
Column = VAR __find = "Colour: " VAR __pos = SEARCH(__find,[Column1]) VAR __semipos = SEARCH(";",[Column1],__pos) VAR __len = LEN(__find) RETURN MID([Column1],__pos + __len, __semipos - (__pos + __len))See attached.
Well, you could get there via DAX but it would be fairly nasty. You would need to create a column for each of your 10 things. You would use a formula like the following for each:
Column =
VAR __find = "Colour: "
VAR __pos = SEARCH(__find,[Column1])
VAR __semipos = SEARCH(";",[Column1],__pos)
VAR __len = LEN(__find)
RETURN
MID([Column1],__pos + __len, __semipos - (__pos + __len))
See attached.
- I'm really not that good with programming.. Uh there is an error in the first line find = "colour:" it says expected token : eof
Are you getting that error in the PBIX I attached? Could be something wonky with the copy and paste of the double quotes if you are copying and pasting out of the forum.
- Ah it's not compatible with my version. I'm having the March version here and I can't install the November one on my laptop from work