Reorder columns on x-axis visuals

[C097986]

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:

order 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.

order 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?

[Bbrown44]

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:

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

[Greg_Deckler]

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?

[C097986 · Accepted solution]

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.