Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Top N filter and legend chart Problem

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!

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

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

        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!