Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to change the number formatting of KPI, currently value is coming as 60.15M but wanted to just value to 1 decimal i.e. 60.1M.
Number formatting is set to Auto but I don't want to change the number formatting
Please suggest.
The format should be '#,##0.0'
As far as I know, it is not possible to change the formatting of numbers in KPI without changing the formatting of numbers in KPI. You could write up some sort of complex rounding/formatting formula and use the "Measure expression" setting, but even that would require switching off "Auto".
True, is there any way that while keeping number format to Auto, number formatting comes in B,M,K format?
If you set the format to auto, then the format will be automated and you won't be able to control it.
There's any number of past discussions on this site about manually adjusting the format to include letters using if() and num() statements, you can look them up if you'd like to go that route.