Hide "other" category from a Donut Chart

Q&A
, ,
1

Hi community!
I need to hide the ‘other’ category from a donut chart visual, I thought it was as simple as a pie chart where you can click the three dots on the right of the visual and have that option

image
image418×158 12.3 KB

But the Donut chart does not have it. Also is not in the Group/Color properties , I have it set to 5 slices. how can I hide the ‘other’ category?
image
image266×285 9.52 KB

image
image195×333 7.33 KB

Thank you for your help!

1 Like
2

Hi @tatia7d

Welcome back and thank you for your question.

Yeah, I agree with you — there isn’t an option like in pie charts. As a workaround, since you’re displaying 5 slices, I’d suggest applying a filter to show the top N values. That way, the “Other” category won’t be displayed.

image
image1624×1011 88.3 KB

Let me know if that helps.

Thank you,
Shravya

3

Hi @shravya
Thanks for the quick response!. So I am seeing that the donut behaves differently now
I need better understanding of the ----By---- section, i see you have a count(max) and a Max in the aggregation.
What do I need to add in there? my chart is based in a string column, so Group/Color is the string column and Value is Revenue(sum).
Is that what also needs to be added in the -----By------ section of the filter? is it just the revenue field?

image
image912×303 29.3 KB

4

@tatia7d

Hello! When you are using a Sum aggregation, your donut chart will behave correctly with the summed values.

For your use case:

  • You can use a string field (like Selected Period Package Class) in the Group/Color section to categorize the data.
  • In the Value section, use Revenue (Sum) as you’re already doing.
  • If you want to show only the top N items (e.g., top 5, 10, or 20), you can apply a top N filter based on the Revenue (Sum). This helps in keeping the chart readable by focusing on the most significant categories.
  • Donut charts are great for comparing values across dimensions, especially when you want to show percentages of a total.

Here’s a reference from the documentation for more details:
:link: Using donut charts – Amazon QuickSight

5

Thank you!
I was able to filter out the ‘other’ category with the op N filter.
We can close this ticket.

1 Like
6

@tatia7d - Great. If you see any option as “Mark it as Solution” then you can mark any of my response as a solution to close this topic.

Thank you,
Shravya