Hide particular boxplots if they do not contain a minimum number of values

[Anonymous]

I have a boxplot with 3 boxes. The different boxes should only be displayed if they contain at least 10 values. I have used the formula below. However, this filtered the whole visual (all three boxes) if one of the boxes contained less than 10 data points. Is there a way to hide individual boxes if they do not contain the minimum number of 10 values?

var _min = minx(allselected(Table),Table[Income])

return

calculate(countrows(Table), filter(allselected(Table), Table[Income]=_min))

The three boxes are divided according to work situation: professional, part-time, amateur.

Thank you for your help.

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest modify the measure formula to add some conditions with the if statement, you can use them to check the current value to block some calculations.

For these block blank values, they will auto-hide by power bi itself.

Regards,

Xiaoxin Sheng

[mahoneypat]

You can do that by adding a variable in your measure to count to total number of points in that box, and then using an IF in your return to return blank for each point if the overall count is too low. 

Pat