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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Juan_Quikin5
Frequent Visitor

Decimal formats varying in table and card visuals

Hi guys!

 

I have the regional settings of my current file in "English (United States)."  However, the auto-display units in my visual card are not matching the format of the following measure for a table visual:

 

SellOut = 
VAR calc = [MGMV]
var decimals = "0.0"
RETURN
    SWITCH ( TRUE() ,
        calc > 1000000 , FORMAT ( calc / 1000000 , "$" & decimals & "M" ) ,
        calc > 1000 , FORMAT ( calc / 1000 , "$" & decimals & "K" ) ,
        FORMAT ( calc , "$" & decimals )
    )

 

Juan_Quikin5_0-1676858715327.png 

Juan_Quikin5_1-1676858753873.png

 

 

The card takes a comma as a decimal separator while the table takes a dot as a decimal separator.

I tried changing the "VAR decimals" part to "0,0", but this format is adding a zero to left whenever the value has just one digit (e.g. $06K)

 

Any idea would be very appreciated! Thanks guys!

2 REPLIES 2
FreemanZ
Super User
Super User

hi @Juan_Quikin5 

try to replace "0.0" with "#.#"

Hi @FreemanZ, I tried it but I get the same result as "0.0". 😕

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.