Remove values from stacked 100% chart under certain value

[JBorges]

Hi,

I need to remove the small percentages (under 5% ) in the following chart:


How can I do this?

Thanks for your help,
Regards.

[Robl]

I'd be looking at doing it in the date.

Perhaps group all the small values together into an 'Other' grouping, so they still appear on the bar chart but they are grouped together with just a single value.

[JBorges]

I'd be looking at doing it in the date.

Perhaps group all the small values together into an 'Other' grouping, so they still appear on the bar chart but they are grouped together with just a single value.

I had already thought in that solution, but the requirements show that i cannot create more groups and must hide the small values in the chart.

Regards.

[Robl]

Can you conditionally format the labels to make the foreground colour transparent when they are under 5%.
I know you can conditionally format the chart colours but I've never tried the labels.

[TheFrenchGuy]

You should try with an "Report expression" in your properties.
Or maybe a specific format as said before :/

[Lynn]

If you remove stuff from a 100% stacked chart then it isn't really reflecting 100% anymore, is it? If you can't lump them all into a single "other" group then can you filter them out of the query altogether? I don't think I totally understand a requirement that wants to hide things in a 100% stacked chart....either you change what the 100% reflects (e.g., only the big stuff with the little stuff filtered out of the query) or you group the little stuff into a single "other" group so that the meaning of 100% is reflecting everything.

[JBorges]

If you remove stuff from a 100% stacked chart then it isn't really reflecting 100% anymore, is it? If you can't lump them all into a single "other" group then can you filter them out of the query altogether? I don't think I totally understand a requirement that wants to hide things in a 100% stacked chart....either you change what the 100% reflects (e.g., only the big stuff with the little stuff filtered out of the query) or you group the little stuff into a single "other" group so that the meaning of 100% is reflecting everything.

I just want to remove the annotations in the chart, i want it to still show the sections of the low percentages but without showing the numbers.