Forum Discussion
Dynamic filtering - bar chart
Hi David,
Thanks for your reply.
Unfortunately, this won't fix the issue. I may have been a bit unclear in the description. Sorry about that. Each of the Assets have several Trello boards related to it, so I do think I will need an explicit slicer and that drilldown won't work for this.
For instance, Asset 1 have 5 Trello boards, Asset 2 have 11 boards, Asset 3 have 7 boards. So when none of the assets are selected in the slicer, I want to visualize all assets in the bar chart with the board names stacked.
But when I select for instance Asset 2 in the slicer, I want the bar chart to show the Trello board names (related to Asset 2) on the axis. And the same when slicing by the other assets. If that makes sense?
If you are saying that a particular Trello board is unique to an asset, it will still work, just the legend on the top level (with Asset as the axis) will be very long. In any case, if you insist on using a literal slicer (drill into is as effective as a slicer IMO) then there is no way that I know of to dynamically change an axis. There are ways to do what you are describing, but with drill down or bookmarks, etc., but not with a slicer visualization (that I know of).