Forum Discussion
Visual for SLA Breach with numbers
I need to create a visual for Average Resolution Rate thats dependent on Priority of the case. It needs to look as below. Im not particular about whether its horizontal or like a tachometer or dial. But all the visual I have looked treats the max value as Green!
Also I have a table where the resolution targets are setup. So if I can use that table to choose the target, then my slicers will work. Otherwise, I can split those into 4 visuals for each priority.
| Priority | First Response SLA (minutes) | Resolution SLA (days) |
| Critical | 60 | 1 |
| High | 240 | 2 |
| Medium | 1440 | 7 |
| Low | 2880 | 14 |
1 Reply
Hi BVBI ,
To create a dynamic visualization of Average Resolution Time based on Priority in Power BI:
- Prepare Data: Import two tables—one with Priority and SLA values, and another with Actual Resolution Time.
- Set Relationships: Link the Priority field between the tables.
- Create Visuals:
- Use a Slicer to filter by priority.
- Create a Bar Chart or Gauge to compare actual time with target SLA.
- Add Constant Lines for each priority’s target resolution time.
- Apply Conditional Formatting: Color-code the results (Green for within target, Red for exceeding, Yellow for near target).
- Optimize and Beautify: Adjust layout, colors, and add labels for clarity.
This will give you a dynamic visualization that updates based on priority selection and compares actual resolution time with SLA targets.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
