Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to 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"
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
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
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.
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"
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |