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.
Community SupportHi 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.
Super UserHi 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
- v-echaithra
Hi alish_b ,
Thank you again for taking the time to explore the “Sunburst by MAQ Software” visual and for sharing your detailed observations.You've rightly identified some of the core limitations of this visual, particularly around dynamic color formatting and the control over sorting subcategories like day numbers. As it currently stands, the visual allows for static color customization through the Format > Data Colors pane, but it does not support conditional formatting driven by DAX expressions or measures.
Given that this visual is developed and maintained by a third-party provider (MAQ Software) and is distributed via the Microsoft AppSource Marketplace, there are limitations to the level of customization and support that can be provided directly within Power BI itself.
To gain more insight into whether specific features such as dynamic conditional coloring, custom sort order, or other advanced formatting options are currently supported or potentially planned for future updates, I would recommend reaching out directly to the MAQ Software support team.
Partner with Power BI Experts | MAQ Software
Best Regards,
Chaithra E.- v-echaithra
Hi PedroBarradas ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E. - v-echaithra
Hi PedroBarradas ,
We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.
We truly appreciate your patience and look forward to assisting you further if needed.
Warm regards,
Chaithra E.- v-echaithra
Hi PedroBarradas ,
We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.
We truly appreciate your patience and look forward to assisting you further if needed.
Warm regards,
Chaithra E.