How can I change bars' sequance of the chart?

[DKhachaturyan]

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)

[v-caliao-msft]

@DKhachaturyan,

In the Query Editor, add a index column.

Regards,

Charlie Liao

[DKhachaturyan]

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.

[DKhachaturyan]

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.

[DKhachaturyan]

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

[chotu27 · Accepted solution]

@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 editorOutput

[DKhachaturyan]

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?

[chotu27]

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

[DKhachaturyan]

Sure. See below @chotu27

[chotu27]

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

[DKhachaturyan]

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

[TomMartens]

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

Regards

Tom 

[DKhachaturyan]

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