Forum Discussion

kgrafton's avatar
kgrafton
Frequent Visitor
8 years ago

Column-based Power KPI Matrix - ID column

 I am using the Power KPI Matrix visual with column-based data, and I'm having an issue. To group the categories together, the visual wants an ID associated with each row, but since each row has all ...
KPI
v-viig's avatar
v-viig
Community Champion
8 years ago

Can you share a data sample for investigation?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • kgrafton's avatar
    kgrafton
    Frequent Visitor
    8 years ago

    I updated my post to include a sample of my data. The first sheet shows the data, the second sheet shows the category hierarchy.

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      Goal ID column must contain values from 1 to 13 in your case. This column must be in Categories table and Scorecard data table.

      After that, you must open Relationship manager to make a relation between two table by using Goal ID as a key column.

       

      As a reference you can use Sample report.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • fraggle's avatar
        fraggle
        New Member
        6 years ago

        I'm having a similar issue that I'm trying to get my head around this.

         

        If using column based data where the column headers relate to the categories, how can creating an ID column in this table relate to a categories in a second table?