Forum Discussion
KPI Target
Mgg , Any time add a column to a visual it takes, some aggregation. or You can create a measure
Target = sum(Target[Target])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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
