Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
setis
Post Partisan
Post Partisan

Force number format on measure in variable

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.