conditional coloring

[Anonymous]

Apply conditional coloring to column in table. The value of column(P1) is coming from a measure. The data is on fortnightly(14 days gap) basis.

The requirement is that if the value(652) of current fortnight(14/03/2022) is less than the previous fortnight(28/02/2022) then the value(652) of current fortnight should be in red colour otherwise in green. Similarily for all the other fortnight values of

that column(P1) i.e next we have to compaire between 28/02/2022 and 14/02/2022 values and so on.

[Anonymous]

It helped me to resolve my query

[v-henryk-mstf]

Hi @Anonymous ,

Whether the advice given by @VijayP  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[VijayP · Accepted solution]

@Anonymous 

create a Datedim table and connect to the main table with date

then create the previous fortnight value the way shown in the snap shot

then create color formula shown in the next snap shot and apply the conditional formatting

background color -> field vlaue -> select the measure