cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pypak001 Frequent Visitor
Frequent Visitor

X-Axis change of order

I am trying to change the order of legend appearance at the X-Axis. 

 

I saw a post and solution for the month order changes but my issue is not month but are general legend titles.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
pypak001 Frequent Visitor
Frequent Visitor

Re: X-Axis change of order

Sorry wrong message. 

 

This is now resolved. I used your SORT and pressed it a couple of times and it eventually sorted in the order the same as they appear on the table.  Thanks

View solution in original post

15 REPLIES 15
Nathaniel_C Super Contributor
Super Contributor

Re: X-Axis change of order

HI @pypak001 

 

Not sure if this is your issue, but if you change the order of your values, it will change the legend.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

pypak001 Frequent Visitor
Frequent Visitor

Re: X-Axis change of order

Hi, Thanks for the quick response.

 

The issue is when they are displayed in a table the order of appearance is different than that of the Cluster chart, the order is back to front. For example, 

Table format 

AA   $ 

BB   $

CC   $

Clustered CC

CC   $ 

BB   $

AA  $

Nathaniel_C Super Contributor
Super Contributor

Re: X-Axis change of order

Hi @pypak001 ,

Go to Power Query, sort your table so it reverses the order (or however you want) Add an index column. That should capture the sort order you wish.  Go back to Power BI, select Modeling Tab, select your column, use the sort by column and choose your index.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Re: X-Axis change of order

Try this:

Click in the top right icon (...) in the Chart, then select the option Sort By, then the name of the collum you want to order.

pypak001 Frequent Visitor
Frequent Visitor

Re: X-Axis change of order

Thanks guys. See below. No manual intervention from me. 

 

Capture.JPGSee the order of legend changes in the CCChart

Re: X-Axis change of order

Have you tried?

 

Click in the top right icon (...) in the Chart, then select the option Sort By "Stage"

 

 

Re: X-Axis change of order

Like this:

 

Capture.PNG

 

pypak001 Frequent Visitor
Frequent Visitor

Re: X-Axis change of order

Tried...

pypak001 Frequent Visitor
Frequent Visitor

Re: X-Axis change of order

It sorts by value and not by the axix legend. Thanks


@mauriciosotero wrote:

Like this:

 

Capture.PNG

 



@mauriciosotero wrote:

Like this:

 

Capture.PNG

 


 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)