cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 ..)

 
 
 

target.JPG

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 6
Highlighted
Super User VII
Super User VII

Re: KPI Target

@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/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Super User IX
Super User IX

Re: 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.

refer: https://www.tutorialspoint.com/power_bi/index.htm



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Regular Visitor

Re: 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)

 

     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
PeriodMarketTarget_SARTarget_ZDTarget_Cov
202001APJ0.0%90.0%5.0%
202002APJ0.0%90.0%5.0%
202003APJ0.0%90.0%5.0%
202004APJ0.0%91.0%5.0%
202005APJ0.0%91.0%5.0%
202006APJ0.0%91.0%5.0%
202007APJ45.0%92.0%5.0%
202008APJ45.0%92.0%5.0%
202009APJ45.0%92.0%5.0%
202010APJ50.0%93.0%5.0%
202011APJ50.0%93.0%5.0%
202012APJ50.0%93.0%5.0%
202001EUR50.0%85.0%5.0%
202002EUR50.0%85.0%5.0%
202003EUR50.0%85.0%5.0%
202004EUR53.0%87.0%5.0%
202005EUR53.0%87.0%5.0%
202006EUR53.0%87.0%5.0%
202007EUR56.0%89.0%5.0%
202008EUR56.0%89.0%5.0%
202009EUR56.0%89.0%5.0%
202010EUR59.0%91.0%5.0%
202011EUR59.0%91.0%5.0%
202012EUR59.0%91.0%5.0%
202001IND0.0%88.0%5.0%
202002IND0.0%88.0%5.0%
202003IND0.0%88.0%5.0%
202004IND85.0%89.0%5.0%
202005IND85.0%89.0%5.0%
202006IND85.0%89.0%5.0%
202007IND87.0%90.0%5.0%
202008IND87.0%90.0%5.0%
202009IND87.0%90.0%5.0%
202010IND89.0%91.0%5.0%
202011IND89.0%91.0%5.0%
202012IND89.0%91.0%5.0%
Highlighted
Community Support
Community Support

Re: KPI Target

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,

 

KPI1.jpg

 

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.

Highlighted
Regular Visitor

Re: KPI Target

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.

 

Mgg_0-1593440152242.png 

 

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

Mgg_1-1593440192269.png

 

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

Highlighted
Community Support
Community Support

Re: KPI Target

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?

KPI1.jpg

 

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])

 

KPI2.jpg

 

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors