Home Dashboard Directory Help
Search

In PowerPivot 2013 model, KPI status thresholds does not always work as expected by IdahoGal1


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 773563
Opened: 12/5/2012 9:41:22 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I created a KPI in Powerpivot 2013 using as a base a measure defined within the workbook. The KPI definition uses an absolute value vs. a calculated value. The problem seems to occur when there is a wide range of possible values - in my model 1 - 150,000 and the 'absolute' value is towards the lower end of the range. In the model, the 'green' threshold is set to < 100, the yellow threshold is 100-500, and the red threshold is > 500.

The problem is that values are showing up flagged as 'green' when they are not - they should show up as yellow. I've played around with the absolute value setting and the thresholds and only when all are set high enough does the color coding work correctly.    A chart is included in attachments that shows the results with different absolute and threshold settings.
Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
ConnectBug773563.xlsx (restricted) 12/5/2012 -
Bug # 773563 (KPI Issue).docx (restricted) 12/5/2012 -