Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
User | Count |
---|---|
47 | |
31 | |
28 | |
27 | |
26 |
User | Count |
---|---|
58 | |
55 | |
36 | |
33 | |
28 |