1 of 1 people found this helpful
At first I thought when I saw the one with the numbers above each other, that there were two separate fields and you wanted to show one above the other. But I realized looking at the Excel that it's just one really long number. I wouldn't recommend splitting a single number onto two lines as perceptually, the viewer will probably think of them as separate numbers.
Since they are really large, perhaps you could put a lookup table on the dashboard, maybe below where the user could look and see the exact value of the bars.
To build on what Hope Stiles said: I would try having the label be in Billions, and have the exact value in the tool tip:
duplicate the Revenue field and call it Revenu (Billions)
Edit the default properties: Currency custom, Units=Billions
Put this field on Rows and on Text
Put the original Revenue field on Tool tip:
Hope this helps
Thanks Hope, I will consider your advice!!
Thanks Jay.Get the answer.