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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Yuiitsu
Helper V
Helper V

Custom sorting

Dear Experts

 

I would like to know if Pie Chart can do custom sorting. Please take a look at my chart below.

I want to show the profit for my top 10 client. 

But as you can see it is skipping my #5,6,8,9.

 

tempsnip.jpg

 

 

7 REPLIES 7
Greg_Deckler
Community Champion
Community Champion

I actually do not see that, no idea what 5, 6, 8, 9 are. Are you referring to the display of labels? You can use a Top N filter in the Filter pane. To the best of my knowledge Pie Charts cannot be sorted??

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

Not sure what do mean by custom sort when you only want top 10. You can drag a measure to a visual filter and select the top 10.

 

If you want on the category(categorical variable) you can define a sort column and mark that as sort column.

 

Sort_by_column.pngSortnewribbion.png

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

As shown in the photo I attached, the pie chart doesnt show the label for top 10 name + selling.

What I want is for the pie chart to show all the labeling for the top 10 customers.

 

I think that is because of space

Just try to increase size or reduce the font size of label

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for your kind reply.

 

Yes I am referring to the display of label. I want to know if it is possible to let it show the top 10 client.

 

I've set the font to smallest but it still does not show the label for the 1st 10 clients.

Is there a way to manually do it?

 

Sorry if there is any misunderstanding in my question.

 

Refer, different ways you can adjust : https://www.tutorialgateway.org/format-power-bi-pie-chart/

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Well I guess there is no way to do it since the tutorial did not mention anything about this.

 

Thanks!

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.