cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djbuncle Regular Visitor
Regular Visitor

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)

 

WaterfallError.pngWaterfall error

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

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
djbuncle Regular Visitor
Regular Visitor

Re: Waterfall error with value containing switch

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.

3 REPLIES 3
mwegener Member
Member

Re: Waterfall error with value containing switch

Hi,

can you provide the PBIX file?

djbuncle Regular Visitor
Regular Visitor

Re: Waterfall error with value containing switch

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.

mwegener Member
Member

Re: Waterfall error with value containing switch

good to know

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 304 members 3,057 guests
Please welcome our newest community members: