Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
abrahamfariaz
Frequent Visitor

Assistance with TOPN in charts and value labels

Hello,

I need help, please, first with the TOP N filter because it's bringing more than 10 pieces of data in the chart, and I understand that it's because the last value is being repeated. Here's an example:

 

abrahamfariaz_1-1692484691029.png

 

I experience something similar when I ask it to bring me the TOP 3 for each month, and when it encounters duplicates, it brings more values.

 

abrahamfariaz_2-1692484795179.png

 

Lastly, concerning the labels, it brings all the labels from a chart when I only want it to bring those of the elements that are visible in that chart.

 

abrahamfariaz_3-1692484886711.png

 

¿Can somebody help me please?

You can download the file from here: https://drive.google.com/drive/folders/1-_ixIAAGYGMf5w5jBWg_EpgweK03LD2M?usp=sharing

Thanks!!

 

4 REPLIES 4
Ritaf1983
Super User
Super User

Hi @abrahamfariaz 
According to the top, you just need to decide what you want to do with your repetitions.
According to the filtering legend of the graph:
Could you please specify where the problem lies.
You have all the values on the graph.
There's just one of them that's really small compared to foreigners

Ritaf1983_0-1692512429797.png

 

 

Hi @Ritaf1983!

Thanks for answering 🙂
Can you explain what you mean with "According to the top, you just need to decide what you want to do with your repetitions." can you please give me an example? I want to show only top 3 or top 10 just I established, but it didn't work

Hi @abrahamfariaz  Top N is top N values.
In case of duplicates in these values range it couldn't be the same N items.
This is just logic, not power bi limitation.
So you need to tell the tool what you want to do with the duplicates.
for example, according to students in class, the following table top 3 are Ron, Riki, Rita, Mark, and Dima because they have the highest 3 grades...

StudentGrade
Ron100
Rita95
Riki95
Mark95
Dima87
Tim20

Ritaf1983_0-1692588901446.png

 

Hi @Ritaf1983 , how are you?

Thank you for your response!

I've heard about this function, but I'm not sure how to apply it since I mostly do counts within the charts, so I don't have a dedicated table for this.

Could you please provide me with an example using one of my charts?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.