Top N filter and legend chart Problem

[Anonymous]

Hi guys, I did a filter using dax, where I get the TOP N Countries by # of Travels.

The problem is that when I display the TOP N, it display the TOP N by the legend I have in my chart.

I wanted to pick up the top 5 countries with # of countries, but it gets the top N by legend.

So If I select top 5 for the top n filter, instead of returning me the top 5 countries, it returns me the top 5 countries by legend (which is region, so it returns the top 5 by region). Anything I can do to still have the legend colors, but to display only the real top 5 countries, and not the top 5 by region?

Thanks!

[Ashish_Mathur]

Hi,

Show your PBI file and the expected result.

[Anonymous]

Here you can see the problem.

My column is ok showing the top 5 because it has no legend, but my graphic is getting the top 5 by region (legend).

I want just the top 5, independent of the region...

[Anonymous]

HI @Anonymous ,

In fact, I also not found suitable functions to solve this scenario, 'topn filter' will filter on summarize records. When you use legend on visual, power bi will auto split summarize records based on their legend and category.

You can try to use measure to replace value field to force display summarize records, but you can't prevent power bi split current data labels.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Friend,

can you give me more info on that:

"You can try to use measure to replace value field to force display summarize records, but you can't prevent power bi split current data labels." - I'm not so sure about what you're saying here...

And what I did to solve that and get what I wanted is just using the legend colors as conditional formatting...

Thanks!