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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All. Hoping for some help on something that seems something that should be fairly simple to achieve but I can't seem to find the solution!
I have a visual that uses multiple column inputs from an Excel spreadsheet (Y-axis) and plots them against a month/year based timeline, 'Raised vs Solved: Smoothed' below:
I want to be able to filter anything away that is less than a given number, say 2, across ALL y-axis inputs (in this case, the different names). The purpose of this is to show whether the different resources pools (people) are becoming too busy and at risk.
The problem I run into is when I try to add a filter to each input, i.e. A. Barnes >= 2, it applies it across all inputs. As I happen to be < 2, it removes the other inputs too! See below:
How do I only apply the filter for A. Barnes to A. Barnes and not A. Barnes & J. Bloggs & J. Doe, etc? Or how do I apply a visual only filter when I have numerous Y-Axis inputs? Obviously the latter of these options would be ideal as I only have to update one filter instead of one for each input.
I don't think I can use a page filter as I don't want to apply it to the other visuals on the page, i.e. 'Solved CCARs' or any other visual that I put on this page.
Names removed to protect the guilty!
Any help would be greatfully recieved.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 37 | |
| 18 | |
| 14 |