Tooltip Formatting

[jerryr125]

Hi - I have a two questions regarding formatting of tooltips:

A tooltip apprears for a bar chart visualization everytime the user hovers over a specific bar.  The tooltip displays field name and the value.

Questions:

1. How can you modify the tooltip to display another name instead of the actual field name (such as "Product Name" instead of "product_name") ?

2. The value being displayed in billions. How can display, for example, 1.23bn instead of 1230000000 ?

(example: "Sales: 1.23 bn" instead of "product_sales: 1230000000" ?

Note: I am using the verision of Power BI on the cloud (SAAS).

Any assistance would be appreciated. Jerry

[Anonymous · Accepted solution]

Hi @jerryr125 ,

Here I suggest you to create a measure as below and then add it into Tooltips.

Format =
VAR _Toolips =
    CALCULATE ( SUM ( 'Table'[Column1] ) )
RETURN
    SWITCH (
        TRUE (),
        _Toolips >= 100000000,
            _Toolips / 100000000 & " " & "bn",
        _Toolips >= 1000000,
            _Toolips / 1000000 & " " & "mn",
        _Toolips >= 1000,
            _Toolips / 1000 & " " & "th",
        _Toolips
    )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.