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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
BTex06
Frequent Visitor

How to filter across multiple colmuns

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.

BTex06_0-1707231639294.png

 

1 ACCEPTED SOLUTION
PijushRoy
Super User
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.




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

3 REPLIES 3
ray_aramburo
Super User
Super User

You can use the card filters on your filter pane to specify that condition, like this:

ray_aramburo_0-1707233899110.png

Repeat the step for the other 2 fields 🙂 

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





PijushRoy
Super User
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.




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





thank you, that was an easy solution.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.