Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power KPI Matrix 3.1.1 Sorting Options

  • 1.  Power KPI Matrix 3.1.1 Sorting Options

    Posted Feb 25, 2020 11:47 AM
    Does anyone know how to make the Power KPI Matrix 3.1.1 sort by a metric instead of default Row-based Metric Name alphabetically? It doesn't matter what I put in the Sort Order field or in the Table properties Category Auto-Sort.

    Trying to sort by MTD or another column YTD which are measures.






    ------------------------------
    Jason Spangler
    DBA
    Monarch Beverage Co., Inc.
    3176120000
    ------------------------------


  • 2.  RE: Power KPI Matrix 3.1.1 Sorting Options

    Posted 14 days ago
    Hi there.

    Don't know if you came right but I bumped into you question today because I had a similar requirement. I used the Category to sort my indicators in a particular sequence and it worked for me.


    Ser is a generated serial number based on my business logic, and not used in the visual for something else if that makes sense.

    Hope this helps.

    ------------------------------
    Louise Dinkelmann
    Senior Business Analyst
    ------------------------------