Waterfall chart on Power BI service is not working correctly

[Ras_Ile]

Hi - I just experienced an issue that has previously not happened.

In my company, we have a waterfall chart showing cash development. 

The graph uses switch variables to calculate the increases/decreases and then shows the resulting total sum.
This works well in the desktop setting and has previosly worked very well on the published report too.

However, I discovered today that the published report does not show the correct total value, but instead shows the final category of the waterfall. 

This is extremely strange, as I have error-searched and cannot find any other explanaition than the fact that the web-browser report contains some kind of issue/bug.

Please see below:
Desktop graph

Power BI service graph

Both graphs in the picture are connected to the exact same dataset. I have also tried to replicate the graph in the dataset (Desktop) and it shows no issue. I have also tried new desktop reports connected to the dataset and no issue. 

The only issue is when the report is published, it shows a different result.

[Anonymous]

Yes please advise progress as we have a production report out that is still showing the error. 

And given the number of people posting with same error over the last week, you'd hope we could get this fast-tracked and be updated on the progress reguarly.

Frustrating!

[JPhoo]

Hi,

Exactly the same problem as others have described. Waiting for fix.

[tamnguyen1395]

Hi All

I faced to this error on PBI web service and can not wait for PBI team too long.

So I changed to another waterfall chart by using get more visual from PBI desktop, and I use the visual below, have format same same as default waterfall chart from PBI desktop. 

Then upload PBI web service, and it works. so You can see my solution as a good way to fix the problem now. THANKS

[Anonymous]

Microsoft Support team, I have looked at my report and tried to change the underlying calculations but still no luck. Impossible to debug easily as the error doesn't show in desktop version, so need to republish to even check.

Has any effort been put into resolving this? Or can you atleast advice on anything that has changed in server updates or something that could have contributed?

For a huge international BI product, this is really dissapointing. 

[v-xiaoyan-msft]

Hi @Ras_Ile ,

Update：

The fix is expected to be completed this week, you can retry to check it out around 2024-02-21.

----------------------------------------------

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

Best regards.
Community Support Team_Caitlyn

[Anonymous]

Are you able to share what the underlying cause was? So I can atleast try hack a fix? 

Still unresolved.

Cheers,

Luke 

[CandiceNaiela]

@v-xiaoyan-msft hi, it's been really frustrating having a report out to consumers that is incorrect. Too many calls are coming in querying this.

Can an update be posted on the status of this situation.

[Anonymous]

Mine is now fixed 🙂 Thanks Microsoft, hope it has resolved for other users too.

Cheers,

Luke 

[CandiceNaiela]

Mine is restored as well. 

Although, 20 days to fix this is entirely unacceptable.

[v-xiaoyan-msft]

Hi all,

This issue has been fixed，please try it again and thanks for your patience.

Best regards.
Community Support Team_Caitlyn