Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a budget table and I would like ti filter out any rows that have $0 Annual Budget AND $0 YTD Budget AND $0 YTD Actual. Is this possible? I am still fairly new to Power BI, so forgive my simple question if it is.
Solved! Go to Solution.
Hi @BTex06
Please create a measure with a combination of three value
Total = sum(Annual budget column) + sum(YTD budget) + sum(YTD actual)
Use the measure in the Visual level filter and set a value greater than 0
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Proud to be a Super User! | |
You can use the card filters on your filter pane to specify that condition, like this:
Repeat the step for the other 2 fields 🙂
Proud to be a Super User!
Hi @BTex06
Please create a measure with a combination of three value
Total = sum(Annual budget column) + sum(YTD budget) + sum(YTD actual)
Use the measure in the Visual level filter and set a value greater than 0
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Proud to be a Super User! | |
thank you, that was an easy solution.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.