Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, can any one please advice me how to do conditional formatting for different SLA with different target in single table.
Have attached the screenshot for info!
SLA Metrics | Nov’19 | Nov'19 Bonus | Dec’19 | Dec'19 Bonus | Feb’20 | Feb'20 Bonus |
Reactive - INC Response (P1) - 95% | 100.00% | ✓ | 100.00% | ✓ | 94.12% | X |
Reactive - INC Response (P2) - 95% | 100.00% | ✓ | 99.04% | X | 99.22% | ✓ |
Reactive - INC Response (P3) - 95% | 98.28% | X | 100.00% | ✓ | 100.00% | ✓ |
Reactive - INC Response (P4) - 95% | 100.00% | ✓ | 100.00% | ✓ | 99.67% | ✓ |
Reactive - INC Restoration (Met1 - P1) - 90% | 100.00% | ✓ | 50.00% | X | 88.24% | X |
Reactive - INC Restoration (Met2 - P1) - 100% | 100.00% | 50.00% | 100.00% | |||
Reactive - INC Restoration (Met1 - P2) - 92% | 97.64% | X | 95.19% | X | 97.66% | X |
Reactive - INC Restoration (Met2 - P2) - 95% | 97.64% | 95.19% | 99.22% | |||
Reactive - INC Restoration (P3) - 92% | 96.55% | X | 88.50% | X | 95.95% | X |
Reactive - INC Restoration (P4) - 92% | 99.40% | ✓ | 98.61% | ✓ | 99.02% | ✓ |
Prod App - SAP (99.4%) | 100% | ✓ | 99.99% | ✓ | 99.88% | ✓ |
Thanks,
Hi @Saranya3_d ,
What is the structure of your basic data? And what are the specific rules?
Best Regards,
Icey
Hi...I am having 30 different Metrics with 30 different targets. For Ex: P1 sla 98%, P2 Sla 96%, P3 sla 94% & P4 sla 90%. Sometimes, few months are missing the targets. So now, the requirement is, if we missed any targets then we should highlight the same in red color.
For common targets, I can apply conditional formatting but I'm not able to apply conditional formatting option for different metrics with differnt targets.
We will be projecting the metrics in row wise formate as mentioned below.
Kindly help me how to do conditional formatting for different targets.
SLA Metrics | Nov’19 | Dec’19 | Jan’20 | Feb’20 |
Quality of User Experience (>90%) | 96.30% | 96.50% | 94.49% | 94.72% |
Quality of User Experience (>75%) | 73.15% | 81.82% | 77.95% | 70.15% |
Reactive - INC Response (P1) - 95% | 100.00% | 100.00% | 100.00% | 94.12% |
Reactive - INC Response (P2) - 95% | 100.00% | 99.04% | 98.20% | 99.22% |
Reactive - INC Response (P3) - 95% | 98.28% | 100.00% | 98.32% | 100.00% |
Reactive - INC Response (P4) - 95% | 100.00% | 100.00% | 100.00% | 99.67% |
Reactive - INC Restoration (Met1 - P1) - 90% | 100.00% | 50.00% | 84.62% | 88.24% |
Reactive - INC Restoration (Met2 - P1) - 100% | 100.00% | 50.00% | 84.62% | 100.00% |
Reactive - INC Restoration (Met1 - P2) - 92% | 97.64% | 95.19% | 93.69% | 97.66% |
Reactive - INC Restoration (Met2 - P2) - 95% | 97.64% | 95.19% | 93.69% | 99.22% |
Reactive - INC Restoration (P3) - 92% | 96.55% | 88.50% | 97.48% | 95.95% |
Reactive - INC Restoration (P4) - 92% | 99.40% | 98.61% | 99.66% | 99.02% |
Prod App - SAP (99.4%) | 100% | 99.99% | 100% | 99.88% |
Prod App - SKYPE (99.4%) | 100% | 100% | 100% | 100% |
WAN Availability - Unmanaged link (99%) | 96.20% | 95.55% | 98.32% | 97.76% |
Tools Availability - SCOM (99%) | 100% | 100% | 100% | 100% |
Thanks,
Saranya
@Saranya3_d , refer this can help
Hi Amit,
thanks for the artical which you shared, i will use this option for straight fit metrics.
however, below is my requirement.
Hi...I am having 30 different Metrics with 30 different targets. For Ex: P1 sla 98%, P2 Sla 96%, P3 sla 94% & P4 sla 90%. Sometimes, few months are missing the targets. So now, the requirement is, if we missed any targets then we should highlight the same in red color.
For common targets, I can apply conditional formatting but I'm not able to apply conditional formatting option for different metrics with differnt targets.
We will be projecting the metrics in row wise formate as mentioned below.
Kindly help me how to do conditional formatting for different targets.
SLA Metrics | Nov’19 | Dec’19 | Jan’20 | Feb’20 |
Quality of User Experience (>90%) | 96.30% | 96.50% | 94.49% | 94.72% |
Quality of User Experience (>75%) | 73.15% | 81.82% | 77.95% | 70.15% |
Reactive - INC Response (P1) - 95% | 100.00% | 100.00% | 100.00% | 94.12% |
Reactive - INC Response (P2) - 95% | 100.00% | 99.04% | 98.20% | 99.22% |
Reactive - INC Response (P3) - 95% | 98.28% | 100.00% | 98.32% | 100.00% |
Reactive - INC Response (P4) - 95% | 100.00% | 100.00% | 100.00% | 99.67% |
Reactive - INC Restoration (Met1 - P1) - 90% | 100.00% | 50.00% | 84.62% | 88.24% |
Reactive - INC Restoration (Met2 - P1) - 100% | 100.00% | 50.00% | 84.62% | 100.00% |
Reactive - INC Restoration (Met1 - P2) - 92% | 97.64% | 95.19% | 93.69% | 97.66% |
Reactive - INC Restoration (Met2 - P2) - 95% | 97.64% | 95.19% | 93.69% | 99.22% |
Reactive - INC Restoration (P3) - 92% | 96.55% | 88.50% | 97.48% | 95.95% |
Reactive - INC Restoration (P4) - 92% | 99.40% | 98.61% | 99.66% | 99.02% |
Prod App - SAP (99.4%) | 100% | 99.99% | 100% | 99.88% |
Prod App - SKYPE (99.4%) | 100% | 100% | 100% | 100% |
WAN Availability - Unmanaged link (99%) | 96.20% | 95.55% | 98.32% | 97.76% |
Tools Availability - SCOM (99%) | 100% | 100% | 100% | 100% |
Thanks,
Saranya
@Saranya3_d , I assume all those on a row are the metrics. I doubt you have to create either conditional formatting for all of them using https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Or create a measure like I suggested last time
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")
and use the field and measure formatting
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |