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

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!