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.
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
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |