Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Waterfall chart on Power BI service is not working correctly

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

Ras_Ile_0-1707376827913.png


Power BI service graph

Ras_Ile_1-1707376876110.png


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.

 

Status: Delivered

Hi all,

 

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

 

 

Best regards.
Community Support Team_Caitlyn

Comments
lucas_bi
Regular Visitor

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
New Member

Hi,

 

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

tamnguyen1395
Regular Visitor

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

tamnguyen1395_0-1708314925573.png

 

 

lucas_bi
Regular Visitor

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
Community Support
Status changed to: Accepted

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

lucas_bi
Regular Visitor

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

 

Still unresolved.

 

Cheers,

 

Luke 

CandiceNaiela
Regular Visitor

@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.

lucas_bi
Regular Visitor

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

 

Cheers,

 

Luke 

CandiceNaiela
Regular Visitor

Mine is restored as well. 

Although, 20 days to fix this is entirely unacceptable.

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi all,

 

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

 

 

Best regards.
Community Support Team_Caitlyn