cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Changing order of clustered column graph

I want to change the order that the Position fields appear in on the Axis of a Clustered Column graph.

Currently they just appear in alphabetical order. I want to be able to specify a particular order. 

Is this possible?

 

Sort clustered graph.png

 

8 REPLIES 8
Highlighted
Microsoft
Microsoft

Re: Changing order of clustered column graph

@aeyre_ppba

 

You can create another column to define the order as you desired. Then use the Sory By function.

Please refer to following documents and thread. Please also let me know if you still have problem on it.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-change-how-a-chart-is-sorted/

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/

https://community.powerbi.com/t5/Desktop/Custom-Sort-by-x-axis-legend/td-p/64402

 

Best Regards,
Herbert

Highlighted
Advocate I
Advocate I

Re: Changing order of clustered column graph

Hi - I already had an additional field that I was going to use as the Sort By.

However, when I select that field, the Sort By Column remains greyed out - I can't apply it.

Why would that be?

 

Highlighted
Microsoft
Microsoft

Re: Changing order of clustered column graph

@aeyre_ppba

 

Could you please make sure that you only select the Position column before clicking the Sort By button?

If issue still persists, could you please share your PBIX file through online file service like OneDrive?

 

Best Regards,
Herbert

Highlighted
Microsoft
Microsoft

Re: Changing order of clustered column graph

@aeyre_ppba

 

Do you have any update about it?

 

Best Regards,
Herbert

Highlighted
Advocate I
Advocate I

Re: Changing order of clustered column graph

Hi Herbert

 

I've tried what you suggested but it hasn't been successful. How do I send you the pbix file?

Highlighted
Microsoft
Microsoft

Re: Changing order of clustered column graph

@aeyre_ppba

 

You can share the PBIX file through online file service and send the sharing link here or through private message.

 

Best Regards,
Herbert

Highlighted
Advocate I
Advocate I

Re: Changing order of clustered column graph

I have sent a private message to you.

 

Thanks

Highlighted
Microsoft
Microsoft

Re: Changing order of clustered column graph

@aeyre_ppba

 

Please try to create another table to define the order for different roles, then create relationship with the original table as below.

 

Changing order of clustered column graph _1.jpg

 

Make the Pos column sorted by Num column.

Changing order of clustered column graph _2.jpg

 

Use Pos column instead of the Position column in the chart.

Changing order of clustered column graph _3.jpg

 

Best Regards,
Herbert

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors