Filter Top N

[Anonymous]

Hello, 

I am trying to filter top 3 activities by highest values. But it shows me weird results as below:

I tried similar charts 2 weeks ago, same data set, it worked but now when I came back, and make a new chart with different metrics, it doesn't work anymore. Any ideas why it is like this and how to fix it?

Many thanks! 

[v-jayw-msft]

Hi @Anonymous ,

Are you using any formulas? Can you please share some sample data?

Best Regards,

Jay

[Anonymous · Accepted solution]

Hi @v-jayw-msft ,

Thank you for your message. I just found out that the problem lies in the dataset itself. There are missing and duplicated values in the opportunity columns, making Power intepret the data that way. It took me long time to investigate this. But thank you very much for all of your help. 

[amitchandak]

@Anonymous, Are you using TOPn, a Visual level filter?

TOPN https://youtu.be/QIVEFp-QiOk

[Anonymous]

Hi @amitchandak ,

Thank you for your answer.

The videos are nice but not the answer I'm looking for. Yes I used top N and visual filter, this is what I did and above is the result I got. It shows me 4 instead of 3. And it should be activity by Opportunity value instead of the other way around. 

I got a similar chart before on the same data set and it worked. 

Do you happen to know what happens when the filter doesn't work for me anymore?