Using stacked bar chart as a slicer - but highlight entire bar when clicked

[pjn]

I'm fairly new to Power BI and have a question regarding the Stacked Bar Chart.

Configuration is as follows:

Axis = Employee Name

Legend = Billable / Non-Billable

Value = Hours

As expected this shows 1 bar per employee, each with 2 segments to indicate the billable and non-billable portions.

My client effectively wants to use the stacked bar chart as a slicer at the Axis (Employee) level rather than the Legend (Billable/Non-Billable) level.

i.e. When I click on an individual segment for an employee, the default behaviour in Power BI is to filter to that employee and segment. Is it possible to configure the stacked bar chart so it visually highlights the entire bar (and subsequently filters to employee only)?

I noticed that one of the online sample dashboards does this but I can't see any option in the chart settings to replicate what he's done. See the 'Engineers Billable Hours' page on this dashboard as an example: http://community.powerbi.com/t5/Data-Stories-Gallery/Business-Sales-Report-PowerBI/m-p/60491

Thanks

Pete

[v-shex-msft]

Hi @pjn,

According to your description, you want to the effect like below?

You can open the "Format" tab and click on "Edit Interactions" to open the interaction UI, then you can modify it:

Notice: click on one visual to active it will show the its interaction for other visuals.

Regards,

Xiaoxin Sheng

[pjn]

Hi @v-shex-msft

Thanks for the reply. I'd tried changing the interactions but still couldn't get the effect I was after. I've added some screenshots below to show it.

With no item clicked in chart, everything is highlighted accordingly (this is okay)

Then when I click on one element in this chart (in this case I clicked the 470.50 section), everything dims except for that single element (this is the default behaviour).

What I'm hoping to achieve is that clicking on either the 470.50 or 1023.50 elements in that chart highlights the entire row rather than the one element I clicked on (screenshot was simulated in Paint because I can't get it to do this!)

I've tried experimenting with Edit Interactions but this only seems to define what happens between charts, and not the behaviour of the chart itself. I couldn't see anything in the Format pane either. It's possible that I'm missing something really obvious though!

Regards

Pete

[v-shex-msft · Accepted solution]

Hi @pjn,

Based on my test, currently stacked bar chart not support multiple select feature.

For you requirement, you can post this to ideas.

In addition, I find a same request for 100% stacked bar chart.

Multiple selection by Legend in 100% Stacked chart

Regards,

Xiaoxin Sheng

[pjn]

Thanks for the confirmation @v-shex-msft

Out of curiosity I've left a comment on the dashboard page I originally linked to, asking the author how he did it. I'm going to assume he's used a custom visual to achieve the effect (or maybe some clever stacking of multiple charts, one behind the other)

Thanks again for doing your own tests and your suggestions.

Pete