Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using the following measure to dinamically generate a string
Case development =
VAR LY = [NrCases(Var LY SM CD)]
VAR LM = [NrCases(Var MTD LM CD)]
VAR OvUndLM = IF(LM >0 , "over", "under")
VAR OvUndLY = IF(LY >0 , "over", "under")
RETURN
"The Nr of cases is currently " & LM & " " & OvUndLM & " last month and " & LY & " " & OvUndLY & " the same month last year"
My problem is that the measures [NrCases(Var LY SM CD)] and [NrCases(Var MTD LM CD)] are showing up in the result as decimal numbers, even though I have them formatted as percentages.
Can I use FORMAT on the variables to force the format as percentage?
Thanks in advance
Solved! Go to Solution.
@setis , format these measures here. As they become part of the text, their value which is <= 1 might be taken.
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
@setis , format these measures here. As they become part of the text, their value which is <= 1 might be taken.
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |