Issue with Dynamic Formatting in Waterfall Chart Total

[Ravenna]

Hi,

I'm facing an issue with a Waterfall Chart in Power BI. I'm using dynamic formatting in a measure, like this:

VAR variation = [ACT vs BP total] 
VAR growth = [% GROWTH ACT x PY] 
RETURN "#,0" & " | " & 
"""" & FORMAT(growth, "0.0%") & """" 

However, in the Total of the chart, the growth value is incorrect—it repeats the first value instead of showing the correct total.

I also tried formatting both values (variation and growth), but then both show incorrect values in the Total.

Interestingly, when I use the same measure in a Matrix visual, the Total displays correctly.

Does anyone know how I can fix this issue in the Waterfall Chart?

Thanks in advance!

Ravenna Santos.

[Anonymous]

Hi @Ravenna 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

[Ravenna]

Hi @Anonymous 

I tried to upload a sample PBIX file here, but it says, "The file type (.pbix) is not supported."

Therefore, I am including a screenshot and the formulas instead.

Category, Value and Year are columns. 

PY YTD = CALCULATE(SUM(Tabela[Value]), Tabela[Year] = YEAR(TODAY())-1)

Value YTD = CALCULATE(SUM(Tabela[Value]), Tabela[Year] = YEAR(TODAY()))

Waterfall label:

Mesure:

Waterfall label = [Value YTD]
Formatting:

VAR valuee = [Value YTD]

VAR growth = [Growth]

RETURN "#,0" & " | " &

"""" & FORMAT(growth, "0.0%") & """"