Skip to Content

Using relativevalue and conditional formatting to implement monthly KPI targets have been met

Dec 14, 2016 at 08:53 AM


avatar image
Former Member


I am using BI 4.1 sp6 and have just read through usage for relativevalue to retrieve a previous value from a measure and would like to know if it is possible to use this function together with conditional formatting (traffic light colors on cells) to highlight whether sales have been met or not in each preceeding months.

Question is what should the formula be for each cell under revenue? The tricky part is the need to count 3 consecutive months of YELLOW. If we look at June, the color should be RED because of the previous 3 months that revenue did not meet targets. Thanks in advance for your ideas!


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers