5 Replies Latest reply on Oct 3, 2016 5:50 AM by Mahfooj Khan

# Dynamic Display value change

HI

I am using tableau 10.I have 1 measures.

I am displaying 1 meaures and 1 dimension in Vertical bar chart.Label enabeled.Now when my measure

Cross 10 Lacs it should display 1M,2M..(Milliean).

same way when it cross 1000000 then it should be 1B,2B....

If very Less than it should be 1k,2k...(Dynamically need to change based on values)

Thanks

Govind R

• ###### 1. Re: Dynamic Display value change

Hey,

The K B M formatting is easily handled depending on the formatting settings for measure being displayed which can be done at various levels. Just selecting proper standard and avoid selecting decimal places will be of immense help. Also go for readjusting the coordinates of axis so that intellisense in Tableau will do the legwork for you.

Have fun!

Dhanashree

• ###### 2. Re: Dynamic Display value change

i created 1 calculated field

Total

if sum([Var_Total_Expense])>1000000

then sum([Var_Total_Expense])/1000000

elseif sum([Var_Total_Expense])<1000000 and sum([Var_Total_Expense])>1000

then sum([Var_Total_Expense])/1000

else

sum([Var_Total_Expense])

end

Now i can able to achieve values.But how can i display dynamic number format. If my values more than >10 Lacs means it should be 1M....

Else 1K..2K....

How we will achieve this.

Thanks

• ###### 3. Re: Dynamic Display value change

Please send your packaged workbook and we can proceed in that direction.

• ###### 4. Re: Dynamic Display value change

I used below formuale

if sum([Var_Total_Expense])>1000000

then STR(ROUND(sum([Var_Total_Expense])/1000000))+"M"

elseif sum([Var_Total_Expense])<1000000 and sum([Var_Total_Expense])>1000

then STR(ROUND(sum([Var_Total_Expense])/1000))+"K"

else

STR(ROUND(sum([Var_Total_Expense])))

End

But i can use this in only tooltip (Bcos this is dimension field).I cant able to use in measure value.

Thanks

• ###### 5. Re: Dynamic Display value change

You can change the default number format of your measure.