Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.