Global Climate Bands 11-17-2024 09:31 AM

[carlosbarboza]

A humble replica made in Power BI, the original graph was made by Gregor Aisch using Datawrapper. Huge thanks to both, for making the dataset available. The feature of error bands was paramount to make this replica possible. In this example, it is possible to combine two lines with error bands. Maybe this possibility could be helpful for visualizing different forecasts with confidence intervals at the same time?

You can read more about the original chart here: https://blog.datawrapper.de/days-with-extreme-heat/

You can download the pbix file below. Feel free to poke it.

eyJrIjoiNjcwZGNhNjgtYjI0Ny00ZWZjLWFmNjgtMDdkMjFkNGU0OWFlIiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9

[orosolin2]

Great. On your experience, you think there's a way to do this using the resources available on PBI?

Regards,

[carlosbarboza]

one combined alternative is: error bars for the lines with arrow endings and custom formatted labels. I don't have an example done with Power BI but let me show the idea with one case I developed in Excel. As indicated with the red arrows (in the image) below, you can see the custom label is "Wall St. crash" and the arrow is a formatted error bar.  Note: with scatterplots in Excel, there is a greater flexibility for this type of enhancements.

[orosolin2]

Excelent suggestion. I'm trying to enhance the storytelling of my PBI reports with these resources and will try your suggestion.

Best regards.

[orosolin2]

Hi!

How did you put the comments on data points (the text followed by the arrows)?

Tks!

[carlosbarboza]

Hi Orosolin2, they are simplying laying behind the main visual. The arrows are basic shapes enhanced and the comments are regular textboxes. I wish we could make them to be dynamic but for this case it was sufficient to be static.