Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.)
In the Power BI model view (which uses the example number 123456.78), you can see them also working.
However they don't work at all on the report. The numbers end up displaying like "7,654,321K" in all visuals.
Removing the text allows the number format to work again (but is completely misleading) ...
... until you set the visual to do some formatting for you.
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
Solved! Go to Solution.
Hi,
Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645
And try this formatting: "#,##,.00 K"
Proud to be a 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"
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.
PBI still seems confused as to what the actual number is though.
But, I can live with that and duplicate the measure without custom formatting when I want to let a visual handle it for me.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
94 | |
89 | |
32 | |
28 |