Forum Discussion

Wonsho's avatar
Wonsho
Frequent Visitor
2 years ago

Power BI Field Parameters Sort Order isue

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. 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Wonsho's avatar
    Wonsho
    Frequent Visitor
    2 years ago

    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.