'Can Power BI's stacked bar chart visualization hide filtered-out value bucket columns?
When creating a stacked bar (or column) chart in Power BI, selecting a name in the visualization's legend highlights all visible portions in each bar/column that match what was selected. Is there a way to completely hide everything in the chart that isn't highlighted until the selection is cleared? The Small Multiples feature accomplishes a similar objective for only a single column from my query, which isn't enough unless I create several visuals (or a new measurement, perhaps?).
I am aware of the Manage Relationships tool, however, I am uncertain whether it provides a path forward. My searches have shown me it is possible to create a different sort order, but that isn't relevant to my objective.
Initial chart, Highlighted chart (actual result), and two prospective expected results
Update: After learning about unpivoting columns, it was better to unpivot the columns containing dissimilar categories that I am charting out. This made it possible to use the slicer visual, just as AmilaMGunawardana suggested.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
