Forum Discussion

twrigglesworth2's avatar
twrigglesworth2
Regular Visitor
10 days ago
Solved

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 ...
  • ShahRukhSameer's avatar
    10 days ago

    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.