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 ...
Need Help
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!