Vizlib Home Try Vizlib

Question about formatting KPI Value based on a dynamic Measure

I have a dynamic measure. Depending on the value selected in a field the resulting KPI could bae a huge number (Billions) a small number or a percentage.

I have tried auto, but then you will see decimals for small numbers (like 4.0) and that is not what we want.

I think I could make percentage work if the number is less than 1, but I struggle with with getting it to show 

35.1k in one situation and 31 if you filter farther down. I see 31.0 instead.

I have tried not formatting the value as a number and that might work, but I will have to clean up the decimal places on the way in and because this is dynamic that actually ends up being a lot of work. 

In this example you can see that if I use "Auto Number" format anything below 100 gets the two decimal places.


If I use the custom I can get the percent I want and lose the two decimal points, but I can never get the (k,m,b) instead of the full number.


I am probably making this more complex than it needs to be. Any assistance is appreciated.

Login to post a comment