Sorting a chart

[soderqvistn]

Hi 

I want to sort this chart not by sum of statusranking or IDs.

I want to the green  81% to be ranked first on top of the chart since it has 81% and followed by that order.

What I've done now is that I created a calculated column giving 1 2 3 depending on the status and sorted by it. But that doesnt work. I want the highest percentage Approved (green) not sum of all or the count to sort the chart.

[soderqvistn]

I created a measure which takes the accepted divided by total rows which I thought would be correct. Its better but still not good unfortunately.

AndelAccepterade =

VAR AntalAccepterade = COUNTROWS(FILTER('JUNK_COMPANIES_STATUS', 'JUNK_COMPANIES_STATUS'[INVITATIONSTATUS] = "Accepted"))

VAR TotaltAntal = COUNTROWS('JUNK_COMPANIES_CONTRACTS')

RETURN DIVIDE(AntalAccepterade, TotaltAntal, 0)

[Anonymous]

Hi, @soderqvistn 

Can you provide example files? This will better help you solve the problem. Please remove any sensitive data in advance.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.