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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors