Forum Discussion
Exclude cells with small sample sizes
Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.
Edit Interactions to Filter
I believe I duplicated this. I created the following data:
EthnicityCategory
| Asian | 1 |
| Asian | 1 |
| Asian | 1 |
| Asian | 1 |
| Asian | 1 |
| Asian | 2 |
| Asian | 2 |
| Asian | 2 |
| Asian | 2 |
| Asian | 2 |
| Asian | 3 |
| Asian | 3 |
| Asian | 3 |
| Asian | 3 |
| Asian | 3 |
| Asian | 4 |
| Asian | 4 |
| Asian | 5 |
| Asian | 5 |
| Asian | 5 |
| Asian | 5 |
| Asian | 5 |
| Black | 1 |
| Black | 1 |
| Black | 1 |
| Black | 1 |
| Black | 1 |
| Black | 2 |
| Black | 2 |
| Black | 3 |
| Black | 3 |
| Black | 3 |
| Black | 3 |
| Black | 3 |
| Black | 4 |
| Black | 4 |
| Black | 4 |
| Black | 4 |
| Black | 4 |
| Black | 5 |
| Black | 5 |
| Black | 5 |
| Black | 5 |
| Black | 5 |
I then put Ethnicity in my Axis, Category in my Label and then Count of Category (just changed the default summation from SUM to COUNT) in my Value. Then, in my filter area for the visual, I set "Count of Category" to "greater than or equal to 5"
Thanks for the help thus far. When I try this, the problem still exists because it doesn't seem to affect the highlighted numbers (see below). I got to this point by clicking on a bar segment from a belonging graph.
I don't have any context in relation to this. Is this visualization configured to have a filter of "Count of Diverse" > 5?
Yes, the visual has a Count of Diverse > 5 filter.
I've pulled a sample from the data and created a sample page. The .pbix file can be accessed here.
Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.
Edit Interactions to Filter