Highlight pie chart slice by filtered selection

calebtyrone
calebtyrone Member
in Cards, Dashboards, Stories

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'.

image.png

Any help appreciated.

Best Answers

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer βœ“

    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.

    image.png

    If you found this post helpful, please use πŸ’‘/πŸ’–/πŸ‘/😊 below! If it solved your problem, don't forget to accept the answer.

  • ArborRose
    ArborRose Coach
    Answer βœ“

    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).

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer βœ“

    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.

    image.png

    If you found this post helpful, please use πŸ’‘/πŸ’–/πŸ‘/😊 below! If it solved your problem, don't forget to accept the answer.

  • ArborRose
    ArborRose Coach
    Answer βœ“

    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).

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • calebtyrone
    calebtyrone Member
    edited July 2024

    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
    ArborRose Coach

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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories