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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
maddypena07
Frequent Visitor

Further filtering on Simple Waterfall visual

Hello all!

I hope that you can point me on the right direction, as I tried to solve this for several days now.

The business case is related to the amount of pieces that can be produced by a group of machines. and how the pieces are lost due to out of program schedules or other reasons.

 

I've created several calculations that account for these conditions and work well and provide the figures that I need. So far I have this for Capacity pcs (i'm gonna focus on one of the measures, as the other ones are similar):

 

maddypena07_0-1740764119329.png

 

and in the visual is presented like this

 

maddypena07_1-1740764340012.png

 

But there are machines that are considered to be offline and need to be filtered out because it impacts the total capacity time:

(only the ones with 0 need to be considered)

 

maddypena07_3-1740764717954.png

but when I add the filter to the waterfall visual, it doesn't work:

 

maddypena07_4-1740764789907.png

 

I've tried to add another condition directly on my measures, but that doesn't seem to work either. Can you help me to know what i'm doing wrong or why the filter is not working?

 

Thank you in advance!

 

 

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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