Bar Chart Legend Dependent on Filter

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.