WEB DuBois Challenge 2025 Plate 25 Assessed Value of Furniture 03-25-2025 13:31 PM

[kinsailgal]

@Archimedean Spiral

x = (a+b * radian angle) * cos(radian angle), y = (a + b * radian angle) * sin(radian angle).  

Fussing with values for a & b made a big difference in the appearance of the chart.

eyJrIjoiYmI2NGQ4NmMtZDVlMS00NzlmLTgwYTYtZDJmMjFlODY3YjNjIiwidCI6ImZiOGIxMTkzLTI0MTEtNDZkMi1hZjliLWE0ZjRkNjA0ZWRhNSIsImMiOjN9

[thefarside]

Oh wow that's a creative solution, well done! I just learned about the challenge (I should read emails I get from them more often), so I'm going to at least try to do challenge 9 and 10 in Power BI.

[thefarside]

Great job! What visual did you use to create the spiral?

[kinsailgal]

@thefarside thank you! I used a scatter plot with big circle marks. I shaped the data in excel first, then created 6 separate charts and overlaid one on the other. As I think about it I believe I could have done it with one chart with a little more shaping in query .... unpivoting and text splitting until I ended up with a single x and y (instead of 5 x's and 5 y's) and a column for the year/color. There are 3 more Dubois Challenge charts to go so I cut bait but still want to play a little more with it.