Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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):
and in the visual is presented like this
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)
but when I add the filter to the waterfall visual, it doesn't work:
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
40 | |
39 |