Power BI Field Parameters Sort Order isue

[Wonsho]

I am using below Field Parameters for chart at bottom and need to order the chart by numbers based on parameter values. Each parameter is result of calculated column from Bi table and counts rows where value is true or checked(

MAA = CALCULATE(COUNTROWS('Bi'), Bi[AA] ="TRUE"))

I am straglling to override the default parameter sorting order which is indicated on the table from 0 - 3).

I want to order bars as numbered above on decending or assending order, 1, 2, 3, 4 or decending order as 4, 3, 2, 1. My attempts are not yielding desired result. Please help. Let me know if more information is needed. 

[Wonsho]

@AnonymousThanks for working on this. Your response can be a solution in certain scenarios. In my case, my real data is huge, a list with over 200 columns and also I need to make several such charts. Going unpivote will complicate things further for me.

[Anonymous]

Hi @Wonsho ,

Try unpivoting these columns in PowerQuery.

Assigning colors to each column and the output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group