Forum Discussion
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.
Hi Anonymous
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.
3 Replies
- PijushRoy
Community Champion
Hi Anonymous
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. - ray_aramburo
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 🙂
