Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |