Introduction Since I watched the solar eclipse from Texas this week, we have a solar theme. We are visualizing the sunrise time each day in 2024 to date. I’m keeping it simple with the line chart core visual, but you can use whatever visual you would like. Requirements 1. Retrieve the data from Data.World. 2. …
2024 Week 15 | Power BI: Visualize sunrise times with a line chart Read More
Introduction In this week’s challenge we are creating an Overlay Histogram. An overlay histogram utilises overlapping columns or bars to compare two populations. In this case, we are utilising the speed dating data from a previous challenge to compare male and female differences in dating preferences. Requirements Obtain the data from the Workout Wednesday 2022 …
Introduction Welcome back to Workout Wednesday! This week’s challenge is for folks who want to practice building reports that do have calculations but do not use complex DAX! I also had a little fun with Microsoft Designer for the images. If you haven’t had a chance to play around with this new AI design tool …
Introduction Welcome to this week’s Workout Wednesday. This week, we are taking advantage of some new features in the February 2024 release of Power BI Desktop. We can now have bars overlap in a clustered column chart and hide the inner borders in a stacked column chart. This week, we’ll use those formatting options to …
2024 Week 9 | Power BI: Use Bar Overlap and Border Formatting Read More
Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations …
2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More
Introduction 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 …
2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns Read More
Introduction Welcome back to Workout Wednesday! We’re taking it back to basics this week and creating a bar chart that uses small multiples and conditional formatting. We’re using the #MakeoverMonday team’s data on New Year’s Resolutions and the design is inspired by a Makeover Monday participant! A huge thank you to Ela Piwowarska for creating her submission and …
2024 Week 3 | Power BI: Back to basics with a bar chart Read More
Introduction In the December 2023 release of Power BI Desktop, some new formatting options were added for bar charts. These enhancements allow us to add borders around bars (and segments of bars for stacked bar charts), change the transparency of the fill color in a bar, and add secondary metrics to data labels. With the …
2023 Week 52 | Power BI: Format Bar Charts with Transparency, Borders, and Detail Labels Read More
Introduction Happy holidays to everyone who celebrates! Join us this week to get some help shopping for your friends and family, using a dataset you provide and a random number generator in Power Query. If Clippy can’t pick a gift, no one can! Have fun and create the random gift generator in whatever way you …
2023 Week 50 | Power BI: Clippy’s Random Gift Generator Read More
Introduction To ensure that a dashboard you have built is running optimally prior to being released to your users, run a performance check on the dashboard and all queries. The dashboard inspector 2.0 identifies different types of bottlenecks, such as slow queries and networks, and provides recommendations to improve the performance. It is also a …
