Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 330

resent the previous year's sales, you could use that as the target. In our ex-
ample, we are using a percentage value, which lends itself well to using the
other option, an absolute value. Let's say that you set a target of 50 percent
of the total cost for all sales. Then you would select the Absolute value op-
tion and put 0.5 into the textbox.
4. Next, you need to define the status thresholds. There are four sample color
grids in the lower right-hand side of the threshold definition. These repres-
ent your options to create your thresholds. They represent how to display the
KPI based on the distance from the target. The threshold options will change
based on the icon set selected.
5. Select the first icon set, which has the red, yellow, and green circles.
6. Next, you need to select the threshold style in the lower left-hand corner,
which has three colors in the order green, yellow, and red. This lets us rep-
resent lower cost percentages as good and higher percentages as bad. At
this point, you would notice a dotted line on the threshold bar named Target .
This bar represents the target value.
7. Our next decision is to split the threshold among our three options. Drag the
left-most marker to the Target bar. It should now have 0.5 as the value above
it. This means that we are marking our target or lower as "good" or green.
8. Next, we need to determine what the range for "concerned" or yellow should
be. You can set this at 0.6 . Even if you do not see that much room on the
right-hand side of the threshold bar, keep moving the marker as it will expand
as you need it to. You can also enter values directly into the white boxes
above the markers.
9. Your finished dialog should look like the following screenshot: