Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |