Forum Discussion
Sunburst with evolution per month
- 2 years ago
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.
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.
- MargNIOP2 years agoHelper I
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 😄
- giammariam2 years agoSolution Sage
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.- MargNIOP2 years agoHelper I
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 ?