Change number value

[sunil-kumar5]

Hi All,

I have a bar chart showing value like 1.65M,12.34M,342.45K,150.90K however the requirement is to show the value as

1M,12M,342K,150K

All the number after point should be removed and K and M should come with exact value.

Please advise

Thanks

[chaorenzhu · Accepted solution]

Sorry I didn't get it. Do you have zero value in your dimension? Maybe try checking "include null values" for your dimension or "include zero values" under data handling?

[sunil-kumar5]

Well, null values didn't work however I have successfully handed over, thank you so much for your quick responses , really appriciated