Highlight pie chart slice by filtered selection

calebtyrone

Hi All,

I have a Supplier Performance dashboard where users will filter by first selecting one of several Suppliers. Most cards on the page would then filter to show only data for the selected supplier.

I want to have a pie chart that doesn't get filtered as such, rather it would 'highlight' the selected Supplier as below. I know I can exclude it from being filtered, but Ideally I would want it to either be highlighted in some way, or grouped so the pie displays only 'Selected Supplier' and 'All others'.

Any help appreciated.

Manasi_Panov

Hello @calebtyrone ,

Instead of applying a filter, you can create a variable that displays the necessary supplier information on all cards. I believe there may be a workaround to highlight only the section from the selected supplier, but further investigation is required. I quickly put this together—it may not meet your exact needs, but it's a starting point. In this Pie chart if the variable selected is Aftermarket, then only the section from the Pie chart of Aftermarket will give a result. Maybe something could be done with an additional color scheme and Beast Mode.

ArborRose

Manasi mentions a possible beast mode calculation. You can create a calculated field that will categorize suppliers into selected supplier and all others.

CASE

WHEN Supplier = Selected_Supplier THEN 'Selected Supplier'

ELSE 'All others'

END

Or us WHEN Supplier in (A, B, C, etc).

Manasi_Panov

Hello @calebtyrone ,

Instead of applying a filter, you can create a variable that displays the necessary supplier information on all cards. I believe there may be a workaround to highlight only the section from the selected supplier, but further investigation is required. I quickly put this together—it may not meet your exact needs, but it's a starting point. In this Pie chart if the variable selected is Aftermarket, then only the section from the Pie chart of Aftermarket will give a result. Maybe something could be done with an additional color scheme and Beast Mode.

ArborRose

Manasi mentions a possible beast mode calculation. You can create a calculated field that will categorize suppliers into selected supplier and all others.

CASE

WHEN Supplier = Selected_Supplier THEN 'Selected Supplier'

ELSE 'All others'

END

Or us WHEN Supplier in (A, B, C, etc).

calebtyrone

Hi Manasi and ArborRose,

I have used both your suggestions and they work for what I was trying to accomplish. Thank you! Some simple colour rules finished it off nicely.

The only negative is that I have to manually add each supplier as value in my variable. It's not a big deal but if new suppliers are added I'll have to remember to add them.

ArborRose

You could probably use an ETL to join the list and make it dynamic.