Need to show the measure values in units changes automatically when it moves out to certain limits

Question & Answer
, , ,
1

I want to show the same measure values in units as millions when it is below 100M and if it goes beyond 100M it should show up automatically in terms of billions.
Is it possible to do like using parameter or any other method in Quicksight?

2

Hi,

you can try to use the Auto setting, when you format the value.

image

If it is not neccesary to aggregate the values in a table, you can create a calculated field and concatenate the value with the correct letter.

concat(toString(value),ifelse(value<100.000.000,‘M’,‘B’))

But this is not a “clean” solution.

3

Hi @thomask ,

Sorry I was not active on last week. Thank you for your idea on my requirement.
I will apply it and let you know on the same