Forum Discussion
Solved
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...
Hi,
Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645
And try this formatting: "#,##,.00 K"
Hi,
Check this link: https://community.fabric.microsoft.com/t5/Desktop/Changing-Number-Format/td-p/3710518#M1208645
And try this formatting: "#,##,.00 K"
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.
