cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

View solution in original post

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.

View solution in original post

mwegener Member
Member

Re: Waterfall error with value containing switch

good to know

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 185 members 2,159 guests
Please welcome our newest community members: