topic Re: Sunburst with evolution per month in Custom Visuals Development Discussion

Sunburst with evolution per month

MargNIOP — Wed, 01 Nov 2023 15:01:36 GMT

Hello Power BI community

I want to create a sunchart to show the sum of the values in my Value column. Here's an example of the chart I have:

I want to create a chart to show the destubution by category and the evolution of categories by month, something like this :

Here's what I was able to create in Power BI, but it doesn't help me because I don't have the evolution by month.

==> I have 19 categories and I want to see the evolution of these categories each month.

Thank you for your help

@giammariam @luojiandanPBI @amitchandak @Ritaf1983 @Ahmedx @dm-p @KerKol @ppm1

Re: Sunburst with evolution per month

giammariam — Thu, 26 Oct 2023 22:34:18 GMT

Hey @MargNIOP, thanks for tag. I'd be happy to give this a shot. Just so I understand, is the evolution a rolling sum of the value over each month per category?

Re: Sunburst with evolution per month

MargNIOP — Fri, 27 Oct 2023 07:26:43 GMT

Hello @giammariam , thank you for your relply

Yes exactly,

Something like this :

Re: Sunburst with evolution per month

giammariam — Fri, 27 Oct 2023 11:23:45 GMT

@MargNIOP, thank you, that's helpful. I'll get started. In the meantime, how would you like to encode the different categories? It looks like the month will be represented by color. I'm trying to think about how we can represent the different categories within each month in the sunburst.

Re: Sunburst with evolution per month

MargNIOP — Fri, 27 Oct 2023 12:33:44 GMT

Thanks for your help,

Yes, the evolution by month can be represented by the graduation of color (please propose other solutions if you have any)

looking forward to seeing your proposition 😄

Re: Sunburst with evolution per month

giammariam — Fri, 27 Oct 2023 23:19:52 GMT

Hi @MargNIOP I was having some trouble getting it to look how you described. The sunburst is a hierarchical chart where the items higher up in the hierarchy are closer to the center. Since you wanted a rolling sum, it actually makes sense to have the months to be in the order starting from outside to inside. This will show that cumulation that you were describing (note how the arc angles for each category get larger the closer you get to the center). Additionally, instead of using color for the months, I found that it made sense to use color for the categories, and then use labels to show which "rings" represent which months. I also included labels for each category.

I know that these are pretty significant deviations from which you first proposed. Let me know your thoughts and suggestions. I want to get the design right before getting it into Deneb and Power BI.

Here is a gist that allows for tooltip interactivity and shows how it was implented in Vega.

Re: Sunburst with evolution per month

MargNIOP — Sat, 28 Oct 2023 14:18:04 GMT

Wow, that's genius @giammariam Thank you so much !

I'm perfectly fine with your proposal, but I dont really know how to include your code in Power BI as my data is not in JSON ?

Re: Sunburst with evolution per month

giammariam — Sat, 28 Oct 2023 14:54:48 GMT

@MargNIOP, that's great, I'll provide a sample .pbix that utilizes this code in Deneb. Deneb takes your dataset and converts it into JSON. In order for me to get you the .pbix, can you either confirm or correct me on the following?

You are providing 3 fields named Month, Cat, and Value. (let me know if you want to add more fields for tooltips, etc., and/or if your dataset contains different field names)
All months will be in the same year. If this is not the case, then I suggest you provide a full date, including the year, for each month. Example: "12/1/2022" for December 2022 and "1/1/2023" for January 2023.

Thanks!

Re: Sunburst with evolution per month

MargNIOP — Sat, 28 Oct 2023 15:14:27 GMT

@giammariam

Here's a complete table for me, I also have the column title and domain that I want to use only for filtering.

For the date, it's OK, I can give the full date.

Thanks again !

Re: Sunburst with evolution per month

MargNIOP — Mon, 30 Oct 2023 07:29:02 GMT

Hello @giammariam

have you found a solution please ?

Re: Sunburst with evolution per month

giammariam — Mon, 30 Oct 2023 16:54:17 GMT

Hey @MargNIOP, here's the .pbix. I hope this works out for you.

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.

Re: Sunburst with evolution per month

MargNIOP — Wed, 01 Nov 2023 09:35:14 GMT

Hello @giammariam

I have tried your code with my dataset, but it seems that the months are not ordered.

Re: Sunburst with evolution per month

MargNIOP — Sat, 04 Nov 2023 13:23:18 GMT

Thank you for your help

Re: Sunburst with evolution per month

giammariam — Thu, 02 Nov 2023 13:44:08 GMT

@MargNIOP, can you include a version that has the full Date instead of just the month name? Also, which would you prefer, the sunburst or the stacked bar chart?

Re: Sunburst with evolution per month

MargNIOP — Sat, 04 Nov 2023 13:24:13 GMT

It would be preferable to have both sunburst visuals and the stacked bar chart, this is an opportunity for me to learn how to create them in Deneb and see which one best suits my needs.
But if you can't, please provide only one.

Thanks again @giammariam

Re: Sunburst with evolution per month

giammariam — Thu, 02 Nov 2023 17:37:38 GMT

@MargNIOP, thanks.

For this:

For example, for the job satisfaction category: in October: 2; November: 2; December: 3; January: 3 ==> The tooltip displays October and January, but I'd like to get October and December, as the evolution took place in December.

What would the actual evolution value be in this scenario? would it be 1 because 3-2=1?

Re: Sunburst with evolution per month

MargNIOP — Thu, 02 Nov 2023 18:26:14 GMT

It should indicate December 3 to know that there was an evolution in December and that there was no evolution in November and January.

it's optional for me to have the difference between the two months in the tooltip

Re: Sunburst with evolution per month

giammariam — Thu, 02 Nov 2023 19:07:08 GMT

@MargNIOP, let me know if this will work. I did my best to try and make sure that the capability labels do not overlap. The tooltip only shows if there has been a change from one month to the next. I didn't do anything with the stacked bar chart, but the stacked bar chart that comes with Power BI should be able to fulfill your needs.

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.