Waterfall chart, add custom label to total column

[zervino]

When creating a waterfall chart I can get the value label for each column, but is it possible to add (or modify) the label of the last total column?

In this example, I would like to add only to the last column (eg. year 2023) an additional text box (or anything similar) showing the % change from the initial column ( so in this case, there is a 25% increase from 2022 to 2023).

[v-yangliu-msft]

Hi  @zervino ,

As far as I know, Tooltip doesn't have an option to align the textbox with the last column, the textbox position will move as the mouse moves over the last column.

You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Liu Yang

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

[v-yangliu-msft]

Hi  @zervino ,

I created some data:

You may want to consider using Toolitp to display .

Here are the steps you can follow：

1. Create measure.

Measure =
var _2023sum=
SUMX(
    FILTER(ALL('AllTable'),'AllTable'[Year]=2023),[Value])
var _2022sum=
SUMX(
    FILTER(ALL('AllTable'),'AllTable'[Year]=2022),[Value])
RETURN
DIVIDE(
    _2023sum - _2022sum,_2022sum)

2. Create a Tooltip page based on the following link.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

3. Result:

Best Regards,

Liu Yang

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

[zervino]

Is there anyway to make the textbox to be aligned with the last column and be on top of the column? I guess this means that the position might be dynamic.