Hi everyone,
I am trying to create map visual in Power BI. My data consists of a list of contacts, their nationlity, and a measure for an average amount.
I can create a map visual with a color scale according to the average amount, but I would like to exclude natonalities for which less than 20 contacts appear in my data.
Does anyone know of an easy solution to handle this issue? Maybe a calculated table that filters out the contacts belonging to a nationality with less han 20 people?
Thanks for any feedback.
I am trying to create map visual in Power BI. My data consists of a list of contacts, their nationlity, and a measure for an average amount.
I can create a map visual with a color scale according to the average amount, but I would like to exclude natonalities for which less than 20 contacts appear in my data.
Does anyone know of an easy solution to handle this issue? Maybe a calculated table that filters out the contacts belonging to a nationality with less han 20 people?
Thanks for any feedback.