Forum Discussion
Using the correct visuals
Hello everyone,
My manager has a picture from an LLM and wants me to bring it to life using Power BI Desktop. I'm very basic in this tool so assume I don't know!
I've got the data in and lined up properly from Autotask PSA but my next roadblock is using the correct visuals.
My questions are...
- Do visuals like this exist within Power BI?
- Which ones should I use to get as close to as possible?
- Is it possible to then click on the visual and it present a list of the tickets that made that number?
The request is to show things like open tickets with a graph comparing it to the last 7 days previous to the date range given with a percentage.
Any guidance or advice is very welcome.
Hi twrigglesworth2,
Yes, this is definitely achievable in Power BI.
For something like the screenshot, I'd start with the new Card visual and use sparklines for the small trend charts. You can create measures to compare the current value against the previous 7 days and display the percentage increase/decrease with conditional formatting for the green and red indicators.
For the KPIs themselves (Open Tickets, P1/P2 Open, Resolution SLA, MTTR, FCR, CSAT, etc.), each can be its own card visual with a sparkline underneath. With some formatting on the cards, rounded corners, icons, and spacing, you can get very close to the look shown in the mockup.
As for clicking a KPI and seeing the underlying tickets, that's absolutely possible. You could either use a drill-through page that shows the related tickets or have a ticket details table on the same page that gets filtered automatically when a KPI is selected.
For example, clicking the Open Tickets card could show the 184 tickets behind that number, while clicking Aged >10 Days could show only the tickets that meet that condition.
If you're trying to replicate the design as closely as possible, Deneb would give you the most control over the layout and styling. However, I'd recommend starting with native Power BI visuals first because they can get surprisingly close without adding extra complexity.
3 Replies
Excellent - thank you both for the responses, shall crack on and see where I get to
Hi twrigglesworth2,
Yes, this is definitely achievable in Power BI.
For something like the screenshot, I'd start with the new Card visual and use sparklines for the small trend charts. You can create measures to compare the current value against the previous 7 days and display the percentage increase/decrease with conditional formatting for the green and red indicators.
For the KPIs themselves (Open Tickets, P1/P2 Open, Resolution SLA, MTTR, FCR, CSAT, etc.), each can be its own card visual with a sparkline underneath. With some formatting on the cards, rounded corners, icons, and spacing, you can get very close to the look shown in the mockup.
As for clicking a KPI and seeing the underlying tickets, that's absolutely possible. You could either use a drill-through page that shows the related tickets or have a ticket details table on the same page that gets filtered automatically when a KPI is selected.
For example, clicking the Open Tickets card could show the 184 tickets behind that number, while clicking Aged >10 Days could show only the tickets that meet that condition.
If you're trying to replicate the design as closely as possible, Deneb would give you the most control over the layout and styling. However, I'd recommend starting with native Power BI visuals first because they can get surprisingly close without adding extra complexity.
- Hi twrigglesworth2,As per your screenshot shared, the cards can be created using Custom Visual - HTML Content (Lite) using SVG based DAX Measures.Refer below links -💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
