I have a calculated field in my powerpivot table.
I want to add a KPI which acts as per following rules
How can I create such a KPI?
I am trying this
But the problem is that the middle peg... cannot be moved below 1. However as per my rule green should be between .2 and .4
val it: unit=()
You can change the absolute value target from 1 to .2 (or something within your middle range). Then adjust the other thresholds as needed.
Seems like the thresholds don't automatically update when you change the target value, so you can switch the target type and then switch it back to get the thresholds to reset. Should look like this.
Let me know if that helps.
Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?