Reply
Regular Visitor
Posts: 24
Registered: ‎03-16-2018
Accepted Solution

Reorder columns on x-axis visuals

I have been trying to reorder the context of my charts on the x-axis. I use the sorting to different options but i still cannot get the exact result that i am looking for. any suggestion anyone on how to fix this.

 first chart shows an order like this:

Capture3.PNGorder from Q1 to Q4second chart shows an order from Q4 to Q1 but the bottom field is also reversed. I changed the sort from accending to decending and this is the result i get.

 

Capture4.PNGorder from Q4 to Q1

 

 

 What i am trying to look for is to get a result that shows an order from Q4 2017 to Q1 2018 with C&I first and Work & Asset last. So go in alphabetical order and chronological order as well (2017 first and 2018 last). Is this possible?

 


Accepted Solutions
Regular Visitor
Posts: 24
Registered: ‎03-16-2018

Re: Reorder columns on x-axis visuals

I tried sort by function many diffferent ways but did not get the result. i just had to go change the data manually to put the year first and the quarter and it fixed it to what i was looking for. thank you anyhow.

View solution in original post


All Replies
Super User
Posts: 10,608
Registered: ‎07-11-2015

Re: Reorder columns on x-axis visuals

Very tough to say without sample/example data. Can you post in a form that can be copy and pasted?

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

But, I will say, are you using any "Sort By" columns?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Regular Visitor
Posts: 24
Registered: ‎03-16-2018

Re: Reorder columns on x-axis visuals

I tried sort by function many diffferent ways but did not get the result. i just had to go change the data manually to put the year first and the quarter and it fixed it to what i was looking for. thank you anyhow.

Highlighted
Regular Visitor
Posts: 40
Registered: ‎05-23-2018

Re: Reorder columns on x-axis visuals

I am having the same issue but with a different data format.  The x axis is a text variable where the default sort varible is Decending Percentage value... See below:

X AXIS ISSUE.JPG

 

 

I want to resort the x axis so that it will go as follows:  CL01, CL02, CL03,...

 

Is there a way to do this?

 

Thanks

~Bryon