topic Re: Custom sorting in Desktop

Custom sorting

Yuiitsu — Wed, 11 Mar 2020 01:41:03 GMT

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.

Re: Custom sorting

amitchandak — Wed, 11 Mar 2020 03:42:13 GMT

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.

Re: Custom sorting

Yuiitsu — Wed, 11 Mar 2020 05:35:25 GMT

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.

Re: Custom sorting

Anonymous — Wed, 11 Mar 2020 05:58:21 GMT

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

Re: Custom sorting

Yuiitsu — Wed, 11 Mar 2020 07:30:59 GMT

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!