Forum Discussion
Solved
sorting
Hello, I have a formatted measure (so a text) which I want to sort by numerical value. My issue is that I have both negative and positive value, so even if I try to use 'UNICHAR' method adding "0" an...
Hello,
Instead of using the FORMAT function which returns text, have you tried dynamic format strings?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
show me what you write, what doesn’t work for you, at least share screenshots
Here, from left to right: what I want to sort, measure I use, measure I'm trying to apply
Insert this measure before positive numbers
REP(UNICHAR(8203),x).
and where are the negatives after them.
for example:
REP(UNICHAR(8203),x)&[positive]
[nigativ]&REP(UNICHAR(8203),x)
X is how many times to repeatThanks but doesn't work because sorting depends from the total length of the string, no matter where 'unichar' is
