Inverse Aggregator
I found a way to do this - not really visually pleasing, but it works. I used a Slicer as the visual, then created a group of my 'Account'[Name] field. I grouped all the existing names except the one customer I want to toggle. Now I'm presented with a visual that inlcudes the grouped values (All customers but the one) and the Ungrouped values (one customer). I have 2 check boxes, when both are checked, every customer is show in the data, when I remove the check on the one customer (ungrouped value) it just removes the data for that one customer. Works, not elegant.
I expect when we get a new customer, I will need to update group so that name is included in the Groups and members area. This feels like a sledge hammer approach to putting in a tack, but it works.
Other suggestions very welcome!
So, the real issue you are having sounds like that you want to see a table with the non-selected names (categories in the inverse aggregator example). In other words, unlike the inverse aggregator which shows a table of just the selected values, you want to show a table of the non-selected values from the slicer. Correct?
That sounds correct. Ideally, it would be awesome if there was a Visualization that allowed for complex filters to be applied so these types of actions would be easy to build.
The ugly part with my solution, if new clients are added, I need to regenerate the groups. If there is another way to make this dynamic as new clients get added, that would be awesome.
