Bar Chart Legend Dependent on Filter

[cake28424]

Hi all! Need some help with a visual:

I have a Power BI report that shows connections between companies. Each row of data features a Company column and Company partner column. I have filters for both Company and Partner Company on this page. When I filter to Company, I want the bar chart - which shows the partnering company count - to have a legend of Partner Company. When I filter to Partner Company, I want the bar chart to have a legend of Company. Goal is to show who these companies are partnering with. Due to another visual, I require both Company and Partner Company filters and aniticipate both to be used by the end user.

How can I make this visual work? I've taught about overlaying two bar charts, each with a different legend but do not know how I owuld hide a visual based on whether a filter is one. 

[cake28424]

Thank you!

[v-nuoc-msft · Accepted solution]

Hi @cake28424 

The proposed solution is to overlay two bar charts and dynamically display them based on the applied filter, which is a feasible approach.

To achieve this effect, you can utilize bookmarks and the selection pane.

First, create two separate bar charts. One chart will have 'Company' as the legend (to be displayed when 'Partner Company' is filtered), and the other will have 'Partner Company' as the legend (to be displayed when 'Company' is filtered).

Use bookmarks to capture the state of your report page for each filter scenario.

You'll need to create two bookmarks:

Bookmark 1: Hide the 'Company' legend chart and show the 'Partner Company' legend chart.

Bookmark 2: Hide the 'Partner Company' legend chart and show the 'Company' legend chart.

Use the Selection Pane: The Selection Pane allows you to control the visibility of visuals on your report page. Use it in conjunction with bookmarks to show/hide the appropriate chart based on the filter applied.

Create buttons. When clicked, the corresponding bookmark will be activated.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.