Forum Discussion
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.
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