Illustration of values, that can be very big but also small
I got one question regarding the illustration of values. I got a KPI that shows how much payment we got. As it may measure a long but also a short period, the values are very different and reach from 100.000.000€ to 1.000€. My intention is to illustrate the values different. When the value of the KPI is about 100.500.000€ I would like to illustrate it as 100,5M €, as it is about 1.000€ it shall also be illustrated as 1.000€. Is it possible the do it like this in QLIK Sense?
As it is always easier to see an example I added two shots of what it looks like now.