Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Power KPI Matrix: no row selection ability and X date axis not sync'd for Sparklines?

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381299

 

I very much like the Power KPI Matrix custom visual.

 

However, I have noticed two oddities and wondered if there are work arounds or if perhaps I am not using the visual properly?

 

1.  There does not seem to be a way to select a row in the matrix and use it to filter other objects on the page.  (Like a table click and select)

 

2.  The spark lines do not all share the same X date axis.  If I have one sparkline that goes from Jan to Dec, and the next row Jan to March, both lines appear just as long.  There is no way to know that the second row stopped in March without hovering the mouse over both rows and comparing the last date in the sparkline.  Same for gaps in data.  Is there some option to align the X axis as well as the Y?

  • v-viig's avatar
    v-viig
    7 years ago

    Got you. We'll consider such a feature but no ETA.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

3 Replies

  • v-viig's avatar
    v-viig
    Icon for Community Champion rankCommunity Champion
    1. Power KPI Matrix does not support selection or filtering. We'll consider such ability but no ETA.
    2. Have you tried to use "Use Common Scale" option of Sparklines?

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • OneWithQuestion's avatar
      OneWithQuestion
      Icon for Post Prodigy rankPost Prodigy
      Yes, I toggled the use common scale and that does fix the Y axis which is very useful. However, the x time axis does not align.
      • v-viig's avatar
        v-viig
        Icon for Community Champion rankCommunity Champion

        Got you. We'll consider such a feature but no ETA.

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]