The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to 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
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.
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.
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
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!