Waterfall Data Labels

[ScotmidDavid]

The data labels on my waterfall chart aren't retaining the measure formatting for some values:

The only thing to change between Test 1 and Test 2 was a date filter - as you can the negative values in the second test have lost the currency formatting as well as displaying with decimal places.

Any suggestions on hoe to resolve?

Test 1:

Test 2:

[ScotmidDavid]

Thanks for the suggestions.

This does solve part of the issue - displaying decimal places when not wanted, but doesn't properly format values over one thousand with the correct thousand indicator.

As you can see, the measure below does have a thousand indicator

The waterfalls in the attached PBIX file display correctly on first load, but when I filter to specific product (say 133939 using the table) the waterfall now has 1 data label incorectly formatted

Current Version - Version: 2.128.1177.0 64-bit (April 2024)

PBIX File:

Link to One Drive 

[v-jialongy-msft]

Hi @ScotmidDavid 

Here are the points that I suggest to check.

1. Check the Data Model for Consistent Formatting: Ensure that the measure used in your waterfall chart is formatted correctly in the data model. You can do this by navigating to the Modeling tab in Power BI Desktop, selecting your measure, and then ensuring the Format is set to Currency. This step ensures that the base formatting of the measure is as expected.

2. Reapply Formatting in the Visualization: Sometimes, reapplying the formatting directly to the visualization can help. Select your waterfall chart, go to the Format pane, and under the Data labels section, ensure that the formatting options are set to your preference. Although Power BI should inherit the formatting from the model, manually setting it here can sometimes resolve inconsistencies.

If the above methods do not help you solve your problem, please provide your test PBIX file and the version number of PowerBI you are using.

Best Regards,

Jayleny

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