PowerKPI Matrix category

Question

Hi,&nbsp;I have a set of data with column based metrics and I have another table with the category associated with the metrics.I followed the instruction in the PowerKPI Matrix 2.0.0.0 file but failed to create the relationship between two tables.&nbsp;Can anyone please help?&nbsp;&nbsp;

vanessafvg · Answer

ceceliakuek&nbsp;please provide screenshots with what you doing, giving an example of your expected result, this post is not very clear

ceceliakuek · Answer

vanessafvg&nbsp;Hi, i have attached the screenshot. thanks!&nbsp;

vanessafvg · Answer

ceceliakuek&nbsp;in query editor you can unpivot the kpi columns of table 1 into rows and then they will be combinedinto one column and you can link them up..&nbsp;so highlight the columns in query editor, from teh tranform menu select unpivot

ceceliakuek · Answer

vanessafvg&nbsp;in that case my metrics would be appeared in rows rather than column and I would not be able to perform calculated column / measures.&nbsp;is there any way if i want to remain it as column based metrics?&nbsp;I am referring to the PowerKPI Matrixfile in below link and I am stuck when i am about to create relationship.&nbsp;https://visuals.azureedge.net/app-store/PowerKPIMatrix.2.0.0.0.pbix

vanessafvg · Answer

ceceliakuek&nbsp; why would it remain in rows, when you build a measure you can just specify in your calculate for which KPI it is.&nbsp;&nbsp;&nbsp;ie KPI 1 =&nbsp;CALCULATE&nbsp;(&nbsp;SUM&nbsp;(&nbsp;table[value]&nbsp;),&nbsp;kpitype&nbsp;=&nbsp;"kpi1"&nbsp;)&nbsp;&nbsp;the other way of doing this is denormalising your table one and just adding a column with the information you need from table 2 which i am assuming is the kpi category via a conditional statement&nbsp;&nbsp;

Forum Discussion

PowerKPI Matrix category

5 Replies

Related content

PowerKPI Matrix Sparkline

Average of categories over vendor

PowerKPI Matrix Sparkline

Matrix table

Matrix Category and Subcategory