Hide bar from Stacked Bar Chart without excluding data/ Percentage of total population while filter

[PaulBoden]

Hi all, 

I have a stacked bar chart showing  individuals with outstanding training by area and job title. I want to see these as a percentage of all individuals however, if I exclude those individuals who have completed all mandatory training to date, I only get percentage values for the sub-set, rather than the whole population.

If I include the full data-set in the chart, filtering out those who have completed the training achieves the same result, and including the values as a separate column diminishes the value of the chart as the smaller values become difficult to differentiate (see below).

Can anyone advise how I can hide a column from the chart without excluding the data? Or alternatively, any other suggestions as to how I might show a percentage of the total population, while only included a sub-set of the population in a chart, would be greatly appreciated.

TL;DR: How do I show in a stacked bar chart the percentage of the total population meeting specific criteria, without including a column for every possible set of criteria?

[v-xiaotang]

Hi @PaulBoden 

Thanks for reaching out to us.

According to the description, I think this may be related to the table in the filter() function. Have you tried using the all() function? If you need to more help, please provide information below, 

(1) a sample file, you can replace raw data with bogus data to protect your privacy.

(2) or provide some sample data that fully covers your issue/question

(3) give your expected result based on the sample you provide

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.