Create a Report which shows team wise hourly achievement comparing with plan with highlighting

[seww]

Hi,

Im new to this and this is really helpful if anybody give me solution.

I want to create a report by using matrix and want to compare with target by using advanced conditional format.but it allows only compare with value.

im showing here excel format i created .i want same one in power bi...please anybody help....

[Seward12533 · Accepted solution]

Create a Measure that compares the value to the target and then set up the conditional formatting based on that measure by using "Color based on"

[v-jiascu-msft · Accepted solution]

Hi @seww,

@Seward12533's solution works in my test. Please try the demo out in the attachment.

1 hour compare =
IF ( MIN ( Table1[1 Hour] ) > MIN ( Table1[Hr Target] ), 1, 0 )

2 hour compare =
IF ( MIN ( Table1[2 Hour] ) > MIN ( Table1[Hr Target] ), 1, 0 )

Best Regards,

Dale

[seww]

Dear Dale,

I used measure option for the variation  and it seems work now.then i could apply condition to compare the value below zero andabove zero.

i got an idea because both of ur suggestions and thanks for that.

[Seward12533 · Accepted solution]

Create a Measure that compares the value to the target and then set up the conditional formatting based on that measure by using "Color based on"

[seww]

---

@Seward12533 wrote:

Create a Measure that compares the value to the target and then set up the conditional formatting based on that measure by using "Color based on"

---

---

@Seward12533 wrote:

Create a Measure that compares the value to the target and then set up the conditional formatting based on that measure by using "Color based on"

---

Thank you Seward12533 for the quick response. i tried it before and didnt happen what i want