Dynamic filtering - bar chart

[Anonymous]

Hi, 

I'm having a issue that I hope someone can help out with. 

The dataset contains data for various assets (e.g. Asset 1, Asset 2, Asset 3), and each asset have x number of boards (Trello boards) attached to it. The Trello boards contains data about various initiatives that employees suggest, and the report also have a slicer that filter by each asset. 

If none of the assets are selected in the slicer, I want the bar chart to show each asset on the x-axis (e.g. Asset 1, Asset 2, Asset 3, Asset 4) with the Trello board names as legend. 
When I slice by e.g. Asset 1, I want the bar chart to show the board names (belonging to Asset 1) on the x-axis. 

Is it possible to accomplish this?

Thanks in advance for any feedback 🙂

 

[dedelman_clng]

If I am understanding your requirements correctly, here is what you can do.

Set up your stacked column chart with an Axis of Asset and Board. Put Board as the Legend, and your value as Value.  Then turn on "Drill Down" and you will drill into an asset

Hope this helps

David

[Anonymous]

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?

[dedelman_clng]

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).