Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering null values on Key influencer visualization

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

Need Help
Tips and Tricks

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        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