Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bottom 5 KPI

Hi All!

 

I'm seeking help on a new dashboard that I am creating. I am trying to find a way to dynamically change an area of my dashboard that is dedicated to KPI's. The way that this section is currently set up is with 5 different graphs that show their KPI's and compares it to the threshold of that KPI. I'll attach a picture for reference. Let's say I have 10 different KPI's that we score sellers on.  I want this area of the dashboard to show their bottom 5 KPI's in a chart view depending on which seller is selected. Is there a way that I can make this work?

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    You can create bookmarks to realize the idea.

     

    Best regards,
    Lionel Chen

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

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Here is one way to approach this

     

    Use the Small Multiples visual from the marketplace (or some other visual that supports small multiples)

    Set it up to make multiple for all KPIs

    Make a measure that returns blank for all but the bottom 5 KPIs with TOPN or RANKX

    Use that measure in the Filter panel for that visual on the KPI field so that only the bottom 5 are shown

     

    Regards,

    Pat

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    You can create bookmarks to realize the idea.

     

    Best regards,
    Lionel Chen

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