Skip to main content
Microsoft Idea

Power BI

Needs Votes

Dynamic selection of column value items in stacked charts via legend values

Vote (11) Share
Bozidar Radivojevic's profile image

Bozidar Radivojevic on 16 May 2017 21:33:26

It would be great to allow dynamic selection of column value items to be displayed in charts by clicking on legend items.

Example, if I have a stacked column chart, with 10 different Column values, it would be great if I could select only 3 of them to display at some point.

Currently, when you click on a legend item, Column values which are corresponding to this item are highlighted, and other column values are displayed in shade colors.

What would be a preferred behavior for me, is that there is a way to instruct visual, that clicking on legend item toggles/hides its corresponding values from the view.
Hidden items would have a hollow circle next to the legend item name, and this value will be removed from the chart view until re-enabled, to allow us to compare individual items, without modifying the report.

I am currently accomplishing this by creating a manually populated single-column table with column item names, a slicer against that manually created column and a wrapper measure for each of the items.
This measure sets the value of an item to zero, if the corresponding slicer item is not selected. This works, but is very ugly, and makes us having duplicate information on the report page.