How to get Set Target Value Kpi

[AvPowerBI]

Hi,

I have the pbix file Target SLA Set Value.pbix in the below one drive

https://1drv.ms/u/s!Aknl2UdxdHn0e_RiVjtr_ySgJEc 

I want the real value for Target on the Line values but it is not showing this, it is doing an Average (I know this is set in my DAX Measure), but do not know which Aggregation function to use? I just show want  the Target value for that Target Type.

The line when hovered over per KPI Type is showing 85 % for each one, I want it to show the value that is showing on the KPI Table as per below

Any ideas?

Thanks

[v-easonf-msft · Accepted solution]

Hi, @AvPowerBI 

After checking your pbix file ,I consider that you need to drag the field DimTargets[Target Type] rather than  Fact[Target Type] to the visual .

Line in the line and stacked column chart   will show the right result  rather  than showing 85 % :

For more details,please check the pbix attached.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.