2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns 01-23-2024 17:00 PM

[Meagan]

I keep seeing a particular visual shared by a Denver-area meteorologist on social media. It seems to be output from weathermodels.com. I thought it might be fun to make a modified version in Power BI, so that is our challenge this week. While we don't have native overlapping columns, there is a native solution achievable using error bars. If you are familiar with Deneb, you can always go that route. I have completed both a native solution and a Deneb solution below. 

While this information might be better visualized with a column range  chart, we are going to stay true to the original chart choice and go with a lipstick plot, also called a nested bar chart. 

For more info, see https://workout-wednesday.com/pbi-2024-w04/.

eyJrIjoiOWIxZjk0NDItOTdjYy00MWRiLWJjMzItMWM2ZWVjZmM1ZGY2IiwidCI6IjU0YTc3ZTU4LTliZjktNDc1OC05M2M3LTk0Y2ZkNmYwNTY3YSIsImMiOjZ9

[andrew_k]

This is great @Meagan  as I do the challenges daily. But i'd love to know how you forced the column widths on the matrix to be a certain width as I can't replicate it 😞

I've been through every setting. My Column headers >> Text >> Text wrap is 'On'. My Column headers >> Options >> Auto-size width is 'off. No luck.

 

[Meagan]

Apologies for the slow reply. I got very busy for a couple of weeks. To make the matrix wider, I turned OFF auto-size width under column headers.