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

How can I change bars' sequance of the chart?

Hi

 

How can I change sequence of the bars? For example, the Total bar below is showing up as the first one, I want to make it as a last one, after Brown theme bar. This is how it is on my table (see below)

 

chart bars.PNGchart bars table.PNG

1 ACCEPTED SOLUTION
Post Patron
Post Patron

@DKhachaturyan Go to query editor-> add conditional column-> and put conditions as below screen shots.

 

after keeping the conditions sort it by column 1 in visual then u will get as required

 

 

 

conditions in query editorconditions in query editorOutputOutput

 

 

View solution in original post

12 REPLIES 12
Microsoft
Microsoft

@DKhachaturyan,

 

In the Query Editor, add a index column.

Capture.PNG

Capture1.PNG

 

Regards,

Charlie Liao

Hi @v-caliao-msft

 

So I followed you guidance it worked, but the chart looks deactivated. If I click on any bar it shows "no available action" warning. Does it have anything to do with "sorting by index"? Any way to make it live and ineractive again but keep the sorting by index? Thanks.

 

See the picture below.

 

no available action.PNG

Hi again @v-caliao-msft,

 

So I followed you guidance it worked, but the chart looks deactivated. If I click on any bar it shows "no available action" warning. Does it have anything to do with "sorting by index"? Any way to make it live and ineractive again but keep the sorting by index? Thanks.

 

See the picture below.

 

no available action.PNG

@v-caliao-msft, thanks so much! I followed your tips and it worked out!

Post Patron
Post Patron

@DKhachaturyan Go to query editor-> add conditional column-> and put conditions as below screen shots.

 

after keeping the conditions sort it by column 1 in visual then u will get as required

 

 

 

conditions in query editorconditions in query editorOutputOutput

 

 

View solution in original post

Hi @chotu27,

 

Thank you for your help. I did as you suggested but it does not give the outputs that you got. Please see below. What am I doing wrong?

 

new column.PNG

 

Capture new c.PNG

@DKhachaturyan Can you show me the screenshot of  conditions that you kept?

Sure. See below @chotu27

 

Capture 455.PNG

@DKhachaturyan i need your pbix file inorder to figure out what issue you have becuase it worked out for me.

 

@chotu27, thank you so much for trying to help with this.

 

It does not look like I can attach a file here. How can I share the file with you?

Hey, to share files upload your file to onedrive or dropbox and just share the link to that file

 

Regards

Tom 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

@TomMartens, thanks. But does it work with Power BI free version? Or is it only possible with Pro?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors