Forum Discussion
Sunburst with evolution per month
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, 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!
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 !
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.
Hello giammariam
I have tried your code with my dataset, but it seems that the months are not ordered.
Thank you for your help
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?