Dynamic Format String Showing Incorrect Value in Card Visual

[kapildua16]

Hi @Everyone 
I’m trying to replicate a Tableau-like behavior in Power BI with dynamic formatting for a commission measure. I created a measure with the following DAX:
commission_formatted_new =
SUMX(fact, fact[fee] * fact[rate_factor])

I then applied a dynamic format string using this DAX:
VAR currency = SELECTEDVALUE('currency'[Destination Currency Symbol], "*")
VAR currentvalue = [commission_formatted_new]
RETURN
SWITCH(TRUE(),
currentvalue <= 1000, currency & " #,0.00",
currentvalue <= 1000000, currency & " #,0,.00K",
currentvalue <= 1000000000, currency & " #,0,,.00M",
currentvalue <= 1000000000000, currency & " #,0,,,B"
)

• In a table visual, the formatting works as expected (e.g., $8.42M).
• However, in a card visual, it shows an incorrect value like $0.00MM.
  
  

  What could be causing this inconsistency between the table and card visuals? Am I missing something about how dynamic format strings work in Power BI?

  Any insights would be greatly appreciated!

  Thanks!

  
  
  

[speedramps · Accepted solution]

Change the format setting in the card from Auto to None.

Otherwsie auto overrise you dynamic settings in the Card

Please click thumbs up and accept solution 

my value = 8421234

Format rule = 
VAR currency = "$"
VAR currentvalue = [my value]
RETURN
SWITCH(TRUE(),
currentvalue <= 1000, currency & " #,0.00",
currentvalue <= 1000000, currency & " #,0,.00K",
currentvalue <= 1000000000, currency & " #,0,,.00M",
currentvalue <= 1000000000000, currency & " #,0,,,B"
)

[speedramps]

Change the format setting in the card from Auto to None.

Otherwsie auto overrise you dynamic settings in the Card

Please click thumbs up and accept

solution 

[bhanu_gautam]

@kapildua16 , Try using

commission_formatted_new =
SUMX(fact, fact[fee] * fact[rate_factor])

commission_formatted_display =
VAR currency = SELECTEDVALUE('currency'[Destination Currency Symbol], "*")
VAR currentvalue = [commission_formatted_new]
RETURN
SWITCH(TRUE(),
currentvalue < 1000, currency & " " & FORMAT(currentvalue, "#,0.00"),
currentvalue < 1000000, currency & " " & FORMAT(currentvalue / 1000, "#,0.00") & "K",
currentvalue < 1000000000, currency & " " & FORMAT(currentvalue / 1000000, "#,0.00") & "M",
currentvalue < 1000000000000, currency & " " & FORMAT(currentvalue / 1000000000, "#,0.00") & "B",
currency & " " & FORMAT(currentvalue, "#,0.00")
)