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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
hansei
Helper V
Helper V

Custom number format display issue

Any of these custom number formats are used to hide 1000s. The second one is a bit clearer with the K appearing inline.

 

#,##0,
#,##0,"K"
0,

 

 

 

 

They all work in Excel as you can see in screenshot. (Strictly speaking, the formats in columns C and E are incorrect, but work anyway.)

hansei_2-1708759031047.png

 

In the Power BI model view (which uses the example number 123456.78), you can see them also working.

hansei_1-1708758925055.png


However they don't work at all on the report. The numbers end up displaying like "7,654,321K" in all visuals.

hansei_3-1708759783332.png


Removing the text allows the number format to work again (but is completely misleading) ...

hansei_4-1708759875099.png


... until you set the visual to do some formatting for you. 

hansei_6-1708759996919.png

 

Oddly, if you set display format while the text is still present, it ends up a little closer to reality, but fixes the problem nowhere else

hansei_0-1708760880287.png

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

Hi,

 

Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645

 

And try this formatting: "#,##,.00 K"





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

2 REPLIES 2
_AAndrade
Super User
Super User

Hi,

 

Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645

 

And try this formatting: "#,##,.00 K"





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Not actually wanting decimal places, I modified to (either of these)

#,##,.\K
#,##0,.\K

 
It makes little sense to me why an unused dot would fix the issue, but it did.

hansei_1-1708773710016.png


PBI still seems confused as to what the actual number is though.

hansei_2-1708773839802.png


But, I can live with that and duplicate the measure without custom formatting when I want to let a visual handle it for me.

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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.