Hello there.
How can I highline only one specific value in the donut chart/ or any diagrams?
For example, I have specific field with different values, but I want to highline only one to provide exact % from the total of others values + hide others values to Others.
Thank you!
Hi @weird_guy,
So, ideally, youâd like to just see the top value based on your metric and then all others show up in the âotherâ category?
For this, you can achieve in the format visual section. Just change your âNumber of slices displayedâ to 1 and it will add everything but your top metric to the âotherâ category.
.
To find the percent against total of others, you could try out this calculated field:
Let me know if you have any additional questions!
Hello @weird_guy !
If you want to highlight one specific value in a donut chart or any other diagram, in addition to what Brett mentioned you can also use field colors as shown in this documentation Working with field level coloring in Amazon QuickSight - Amazon QuickSight.
Additionally, if you want to highlight specific values in a table visual type, you can apply conditional formatting. I have attached some documentation that goes through how to apply conditional formatting step-by-step and in addition mentions the visual types conditional formatting is available on. Below, I have also added an example with screenshots on how to achieve this by using a table visual type using a sample dataset.
Conditional formatting documentation: Conditional formatting on visual types in QuickSight - Amazon QuickSight
From here select the first option of âConditional formattingâ. In Conditional formatting view, click Select a column, in this example I selected the âDiscountâ column. This should look like screenshots two and three.
Now select âAdd background colorâ and you can specify and conditions I did the following:
To add multiple conditions select â+ add conditionâ which is found at the bottom.
Please let us know if you have any additional questions!
Hello @Brett @sabbahh
Thank you for your support.
@Brett Ive changed Number of slice to 1. Yes it works!
But how to change displayed specific metric? Id like to show specific reason compared to other
Thank you.
Hi @weird_guy,
Unfortunately there are still limitations with pie and donut charts on what you can display by default. I would suggest potentially adding a tool tip that shows the metric youâre looking to bring more attention to. That way, when you scroll over each section, it will provide that comparison.
