Filtering null values on Key influencer visualization

[Anonymous]

Hi!
Does anyone know how to effectively filter out the key influencer visualization?
The dataset that I am using has many null values and if I filter out the null using the filter then that reduces the value( amount of responses) which scales my answers.
I am using multiple rows and columns and so the filtering will filter out the null values on that specific column but will get rid of important data in the other columns.
Was just wondering if anyone had the same issue and can help me with this?

Thank you in advance

[v-janeyg-msft]

Hi, @Anonymous 

Please describe your needs in detail, and I will see if we can achieve the effect you want by customizing the measure.

Like: 

measure=if(table[column])=blank(),0)

Please share some sample data and your desired result and feel free to ask me.

Best Regards,
Community Support Team _ Janey

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

[Anonymous]

Hi @v-janeyg-msft,

Thank you for your reply.

I was meaning if you use the filter on the visual. It reduces the number of rows.

This would be find if you are using a single colum but I am wanting to use multiple colum that has different null values in differnt rows and columns.

If I filter out the null value, which gets rid of the entire row I will essentially loose important data. 

So I was just wondering if there is a way around this? 

[v-janeyg-msft]

Hi, @Anonymous 

You need to share some sample data and your desired result so we can check if it has a workaround.

Best Regards,
Community Support Team _ Janey