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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
djbuncle
Helper I
Helper I

Waterfall error with value containing switch

Hi.

I'm having trouble with a waterfall chart output whereby the value for each category returns 0 (seen in red in the screenshot). The value slices correctly with the elements when in a table or matrix visual (seen in green below), so I can't see why it wouldn't work with the waterfall.

The only complexity is that the [PR Value] uses a switch statement so that the data can be viewed in an unpivotted format.

E.g. [PR Value] := SWITCH( SELECTEDVALUE( Revenue[Element]),

"GGR", [GGR],

"Bonus Costs", [Bonus Costs],

...

0)

 

Waterfall errorWaterfall error

Can anyone provide some insight as to why this won't work?

Thanks.

1 ACCEPTED SOLUTION

Hi @mwegener. I actually solved this, the issue was that within my SWITCH statement I had different formatting for the various metrics I was using. Some #,0 and others #,0.0. This was enough to upset the waterfall visual. After removing the formatting it worked fine.

View solution in original post

3 REPLIES 3

Hi,

can you provide the PBIX file?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Hi @mwegener. I actually solved this, the issue was that within my SWITCH statement I had different formatting for the various metrics I was using. Some #,0 and others #,0.0. This was enough to upset the waterfall visual. After removing the formatting it worked fine.

good to know

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.