The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Hi,
Show your PBI file and the expected result.
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...
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
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |