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...
Need Help
Tips and Tricks
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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