Forum Discussion
SQDCP Daily Dashboard
Hello! Is it possible to create a sunburst chart to replicate the SQDCP daily status according image below? Basically it would be the month's view of each day's performance, being green above the target, red below the target, gray for days not worked and white for days to be worked.
Hi PedroBarradas
Here is a few guides for creating sunbrust:
https://visualitics.it/how-to-create-a-sunburst-chart-in-tableau/?lang=enhttps://github.com/microsoft/powerbi-visuals-sunburst
https://www.youtube.com/watch?v=vvknQ_znml4
Please note, from a UX and data visualization perspective, the sunburst approach you're considering is not the most effective way to present this type of data. Here’s why:
The brain struggles with circular comparisons – interpreting angles and radial segments is cognitively demanding, especially when repeated across multiple visuals.
Low continuity – each "wheel" stands alone, and by the time a user decodes one, the context of the previous is already forgotten.
No overall picture – it's hard to scan across all metrics and quickly spot which days had multiple issues (e.g., “on day 11, three KPIs were below target”).
Recommended Alternative:
I suggest using a heatmap-style table, as shown in the image I attached. It’s organized by rows (lines or KPIs) and columns (days), with color highlighting to indicate performance.In the ideal setup, only the red (under-target) days are highlighted, to focus user attention on where process improvement is needed.
A secondary (less preferred) option is to color also the successful/neutral days (e.g., green, blue, or gray), though this reduces contrast and increases visual load.
Benefits of the heatmap approach:
Natural left-to-right, top-to-bottom reading flow
Compact overview of all metrics at once
Easier comparison across days and KPIs
Immediate identification of exceptions and patterns
The pbix with my example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
10 Replies
- Ritaf1983
Super User
Hi PedroBarradas
Here is a few guides for creating sunbrust:
https://visualitics.it/how-to-create-a-sunburst-chart-in-tableau/?lang=enhttps://github.com/microsoft/powerbi-visuals-sunburst
https://www.youtube.com/watch?v=vvknQ_znml4
Please note, from a UX and data visualization perspective, the sunburst approach you're considering is not the most effective way to present this type of data. Here’s why:
The brain struggles with circular comparisons – interpreting angles and radial segments is cognitively demanding, especially when repeated across multiple visuals.
Low continuity – each "wheel" stands alone, and by the time a user decodes one, the context of the previous is already forgotten.
No overall picture – it's hard to scan across all metrics and quickly spot which days had multiple issues (e.g., “on day 11, three KPIs were below target”).
Recommended Alternative:
I suggest using a heatmap-style table, as shown in the image I attached. It’s organized by rows (lines or KPIs) and columns (days), with color highlighting to indicate performance.In the ideal setup, only the red (under-target) days are highlighted, to focus user attention on where process improvement is needed.
A secondary (less preferred) option is to color also the successful/neutral days (e.g., green, blue, or gray), though this reduces contrast and increases visual load.
Benefits of the heatmap approach:
Natural left-to-right, top-to-bottom reading flow
Compact overview of all metrics at once
Easier comparison across days and KPIs
Immediate identification of exceptions and patterns
The pbix with my example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- alish_b
Hey PedroBarradas ,
Personally, I think it is a cool visual (and refreshing to see something different once in a while). I do agree with Ritaf1983 as well, circular charts with more than five or so categories do invite a lot of cognitive load. That being said, the Sunburst chart or even Donut chart has limited formatting control at present to give you your desired output (Well frankly, I tried and failed but there are people smarter than me in this forum and I hope they can give you some genious solution).
I was playing around with your idea and found a visual called 'Calendar by Tallan' (I have attached visual sample) which might be interesting. (Basically I fit the Date field of my Date dimension table to its 'Date' field, then created a measure which would give three values 0, 1, 2 coresponding to categories say Not Worked, Not Met Target, Met Target, activate Diverging color, set Minimum to 0 (Not Worked) with color gray, Center to 1 (Not Met) with color Red and Max to 2 (Met) with color Green. I would turn add a last month filter to the visual, turn off the tooltips (unless you want to educate the user about the arbitary codes you used) assuming you have a details table in the report page that this calendar visual can slice and yeah that is it.)
Hope it helps!Hello, alish_b!
Does it make sense to create shapes for each day of the month with conditional formatting following the rule of 1, 2, 3, and 4?1st - Green (above target)
2nd - Red (under target)
3rd - Gray (non worked
4th - Blank value
v-echaithraCommunity Support
Hi PedroBarradas ,
Power BI doesn't have a native sunburst chart, but you can achieve a similar visualization by using the “Sunburst by MAQ Software” custom visual. Start by adding it from the Visualizations Marketplace, then assign your fields in a hierarchy such as Month > Week > Day. If the visual doesn't support conditional formatting based on your data, you can manually customize segment colors by going to Format > Data Colors, where you assign green for "Above Target", red for "Below Target", gray for "Not Worked", and white for "Future Days" to reflect daily SQDCP performance across the month.
Sunburst by MAQ Software
Best Regards,
Chaithra E.
