Forum Discussion
KPI Target
Hi all, I'm new to powerBI and having a mistake with the KPI target visualization.
I created an easy chart with the KPI score but I'm not able to add the target because I cannot show the monthly data but seems I need to apply some calculation (averege, count ..)
Any idea about it? How I can aggregate the target data?
I know it's a easy question but I going crazy trying to solve it ... thanks
6 Replies
Mgg Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Mgg , 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.
