Forum Discussion
Power KPI Matrix Setting Targets
Microsoft EmployeeHello,
First of all it is necessery to clarify what type of data format you use Row-based or Column-based.
Also you can switch matrix from marketplace into table format and you will see how data is structurized.
For KPI Status visualization matrix uses field from "KPI Indicator Index" bucket but you need calculate that index for your data regarding your own criteria comparing actual data and comparison data in a row.
For instance, you have actual data in a row as 8 and your target data is 10, let's suppose that it is 80% of target and you can suppose that is is a good result and bind it to index 1, but for actual value 6-8 you can suppose that it is average result and bind it to index 2, 5 and lower is bad and bind it to index 3. Finally you wil get something like the following:
| Actual | Target | KPI_Index |
| 8 | 10 | 1 |
| 6 | 10 | 2 |
| 4 | 10 | 3 |
Then you need set up colors and icons for corresponding indx only in the format panel.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]
v-evelkThank you, that is helpful!
Another question about the matrix custimization, is it possible to add an indicator color in the Second Comparison?
It doesn't seem to be an option...- v-evelk
No, it is impossible and we aren't sure that it has a sense.
If you suppose that it is a valuable option you can create an idea here and if it gets a lot of votes we will consider to add this feature in the next releases.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]