Forum Discussion
KPI Target
Thanks,
here attached you can find a matrix with 3 different KPI.
I want to show in chart to compare with the monthly results (period) for different area(Market)
| Period | Market | Target_SAR | Target_ZD | Target_Cov |
| 202001 | APJ | 0.0% | 90.0% | 5.0% |
| 202002 | APJ | 0.0% | 90.0% | 5.0% |
| 202003 | APJ | 0.0% | 90.0% | 5.0% |
| 202004 | APJ | 0.0% | 91.0% | 5.0% |
| 202005 | APJ | 0.0% | 91.0% | 5.0% |
| 202006 | APJ | 0.0% | 91.0% | 5.0% |
| 202007 | APJ | 45.0% | 92.0% | 5.0% |
| 202008 | APJ | 45.0% | 92.0% | 5.0% |
| 202009 | APJ | 45.0% | 92.0% | 5.0% |
| 202010 | APJ | 50.0% | 93.0% | 5.0% |
| 202011 | APJ | 50.0% | 93.0% | 5.0% |
| 202012 | APJ | 50.0% | 93.0% | 5.0% |
| 202001 | EUR | 50.0% | 85.0% | 5.0% |
| 202002 | EUR | 50.0% | 85.0% | 5.0% |
| 202003 | EUR | 50.0% | 85.0% | 5.0% |
| 202004 | EUR | 53.0% | 87.0% | 5.0% |
| 202005 | EUR | 53.0% | 87.0% | 5.0% |
| 202006 | EUR | 53.0% | 87.0% | 5.0% |
| 202007 | EUR | 56.0% | 89.0% | 5.0% |
| 202008 | EUR | 56.0% | 89.0% | 5.0% |
| 202009 | EUR | 56.0% | 89.0% | 5.0% |
| 202010 | EUR | 59.0% | 91.0% | 5.0% |
| 202011 | EUR | 59.0% | 91.0% | 5.0% |
| 202012 | EUR | 59.0% | 91.0% | 5.0% |
| 202001 | IND | 0.0% | 88.0% | 5.0% |
| 202002 | IND | 0.0% | 88.0% | 5.0% |
| 202003 | IND | 0.0% | 88.0% | 5.0% |
| 202004 | IND | 85.0% | 89.0% | 5.0% |
| 202005 | IND | 85.0% | 89.0% | 5.0% |
| 202006 | IND | 85.0% | 89.0% | 5.0% |
| 202007 | IND | 87.0% | 90.0% | 5.0% |
| 202008 | IND | 87.0% | 90.0% | 5.0% |
| 202009 | IND | 87.0% | 90.0% | 5.0% |
| 202010 | IND | 89.0% | 91.0% | 5.0% |
| 202011 | IND | 89.0% | 91.0% | 5.0% |
| 202012 | IND | 89.0% | 91.0% | 5.0% |
Hi Mgg ,
Sorry for that we did not understand how you want to show. If you want to compare with the monthly results for different Market, we suggest to use a period slicer and three Pie chart.
The result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your support.
The expected result is to have 3 different chart ZD, SAR and Cov.
In each chart I want to show the score (no problem about it) and the monthly target.
In the table posted in the previus post the were the targets.
The following chart present the score for different area (Colum) and I want to add the line with the target (now are showing another paramiter not needed.
In the second one there is the score and the target but for the target is applied a calculation (Count) instead I want to show the value only
The last but not the least, using the filter implemented in the report (no problem with filter) I want to show the result and target only for the selected area
Regards
Hi Mgg ,
We have a little confused about your issue. There is no ZD Score data in your sample data, is the ZD Score from other table or is the ZD Score a measure?
What is the calculate logic of the monthly target? Is each market getting an average Target every month?
For example, in 202001, is the target_Cov (5% + 5% + 5%) / 3?If it is that you want, you need to create three measures and use Line and clustered column chart.
Target_C = AVERAGE('Table'[Target_Cov])Target_S = AVERAGE('Table'[Target_SAR])Target_Z = AVERAGE('Table'[Target_ZD])If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?
It will be helpful if you can show us the exact expected result based on the tables.
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly