Hello,
I had a question about how I can abbreviate tooltips to show Millions or Billions when you hover over the visual. When I imported my data I did so in whole dollars but the problem I am having is that I can abbreviate the "data labels" that show up in the visualization but when I hover over the visual the tooltip shows the whole dollars which is enormous and distracting. How can I get the same abbreviation that shows up in the actual visual in the tooltip?
Thanks in advance for the help on this.
Rob
Hi Rob,
At this point in time the number format displayed in the ToolTip comes from the format of the column that is set in the modelling tab.
Unfortunately, you can't set a column/field to display in millions or billions so the workaround is to create a measure that divides the result by 1,000,000 or 1,000,000,000. Make sure the name of that measure makes it clear that the values are in M or bn as this name is what you'll see in the ToolTip.
Mynda
Thanks Mynda, I hadn't thought of that approach.
