Forum Discussion

manjirit's avatar
manjirit
Helper I
8 years ago
Solved

Power KPI matrix

In Power KPI Matrix custom visual,  the Sparkline by default shows all the data points available in the table. Can I restrict the Sparkline to show only past 3 or 5 data points?

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi manjirit,

    Have you resolved your issue? If you have, please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

    Best Regards,
    Angelia

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi manjirit,

    Have you resolved your issue? If you have, please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

    Best Regards,
    Angelia

  • rexii23's avatar
    rexii23
    Advocate I
    8 years ago

    This doesn't appear to have been answered yet. I would also like the ability to filter the sparkline dates specifically.

     

    For example, my KPI can show yearly performance, but I would like to keep a tab on the performance in the current WEEK. The sparklines would be perfect for this secenario.

     

    Please consider adding this into a future version!

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi manjirit,

    You can add a date slicer with between mode, select the date range in the slicer as follows.



    Best Regards,
    Angelia

    • v-uprav's avatar
      v-uprav
      Frequent Visitor
      8 years ago

      Hi Guys,

           I just tried to use Power KPI Matrix custom visual. But not able to achieve what I need and also not sure whether this control can fulfill my requirement. 

       

       

      Here is my requirement:

       

      1. RowName is the first column in the matrix (which should be KPI Name)

      2. Next columns - 7  (will be all 7 columns which are last 7 months Aug 2017 - Feb 2018 which have numeric/percentage values)

      3. Next column should be sparkline (which shows line chart with the help of values of all 7 month values)

       

      so all in all my Power KPI Matrix should have 9 columns.

       

      Is this requirement be achieved using this new Power KPI Matrix custom visual?

       

      Thanks

      Chary