Forum Discussion

SgY's avatar
SgY
New Member
7 years ago

MS Power KPI & order by value

Hi,

There are codes of institution on the horizontal axis, the results of these instituiton are on the vertical axis. The results were made by Measure. The problem is that I cannot order the results in descending order by value. Would you like to have a solution?

thx

SgY

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi SgY 

    As tested, it seems impossible currently.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • SgY's avatar
      SgY
      New Member
      7 years ago

      Hi Maggie,

      Thank you for your reply!

      I got a potential solution, as you can see below:

      I ordered the rows descending by the institutes' values. I created a new, index-type column, where the maximum institute's value were linked to the minimum index value and so on. The created index value were put on the graph's X axis that is automatically arranged in increasing order by Power KPI. This way, whichever filter I use for the rows, the institutes' values will always be descending on the graph. If a KPI is set (the horizontal line on the graph), it can be calculated how many institutes are above and below the KPI.

      What do you think, could it work this way?

      Regards,

      SgY