Forum Discussion
SQDCP Daily Dashboard
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.
Super UserHey 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.- alish_b
Hi v-echaithra ,
I tried this visual. I loved the animation feature and I might actually use this some time in the future so thanks for the introduction to this visual. However, I think it lacks cutomization (and if it has, it surely is not intuitive) as I could not change the color based on condition and surprisingly even sorting. (I have a date dimension table and I added 'Month Name' to Category and Day Number (1-31) in the Subcategory, and populated the measure appropriately. Result I got was a Sunburst with Data Color set at Month level and the day numbers ordered around in circle with increasing measure quantity in anticlockwise direction, both of which I could not alter). Do let me know if I am overlooking some option or these are indeed the limitations of the visual.
Thanks,
Alish
- alish_b
Hello PedroBarradas ,
I would not recommend going down this route. The sheer number of measures you will have to write and the shapes you will have to add will be insane. Additionally, the shapes do not give provide significant insight or even the ability to slice any details table (something users will ask for 9 out of 10 times) to undertake this effort.
