SQDCP Daily Dashboard

[PedroBarradas]

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.

[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!

[PedroBarradas]

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

[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.

[v-echaithra]

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

[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 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.

[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.

[Ritaf1983]

Hi @PedroBarradas 
Here is a few guides for creating sunbrust:
https://visualitics.it/how-to-create-a-sunburst-chart-in-tableau/?lang=en

https://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.