Custom sorting

[Yuiitsu]

Hi Experts!

I have a question with regard to sorting my graphs. Please take a look at the screenshot

So now my graph is sort according to the highest to lowest margin. But I want to instead sort it by highest selling to lowest selling.

Please let me know if it is doable and the steps to do it.

[amitchandak]

You put that measure on tooltip and go to three dots on the chart change the sort.

If you always want like that. This for columns and fields. You have sort column option

Appreciate your Kudos.

[Yuiitsu]

Thank you for your kind reply.

I am trying to figure out your instruction but unfortunately I dont quite get it (I am a beginner in power BI).

What do you mean by put that measure in tooltip?

When I click MarginTotal, the Sort by column button is grey out...

Sorry to have to trouble you to explain in more detail.

[Anonymous · Accepted solution]

Hi @Yuiitsu ,

When you say that you want to sort it from highest selling to lowest selling, is that the data that is captured in "Order(bill to)"?

1. If so, you should be able to change the sort by selecting the three dots (...) from the upper right corner of the column chart.  Select "Sort by" > "Order(bill to)".

2. If that doesn't work, drag your "selling" measure/field into the Tooltips field.  Then try the steps from #1 again. 

HTH.

Michele

[Yuiitsu]

OH I SEE.

ok my graph is placed too near to the top so I didnt see the (...) at all and I kept wondering where is the (...) that everyone is saying.

Thank you! My issue has been resolved!