2023 Week 11 | Power BI: Determining trend with LINEST
Determining trend for use in smart narratives with DAX LINEST and Power BI
Power BI
2023 Week 10 | Power BI: Mapping Cities with Michelin Star Restaurants
Introduction Note from the Editor: This week we have our first bilingual WoW for Power BI! Below you will find both the Spanish and English instructions for the exercise. Please note that the solution video is in Spanish, but auto-generated captions are available in English. If you enjoyed this, please let us know in the …
2023 Week 10 | Power BI: Mapping Cities with Michelin Star Restaurants Read More
2023 Week 09 | Power BI: Create a table with custom and built-in microcharts
Introduction This week we are making a table with microcharts (sparklines). Power BI does offer built-in sparklines, but sometimes we want formatting options not available with the defaults. Our challenge this week uses both the built-in sparklines and custom SVG images in a table. Requirements Create a custom column with the following logic: If the …
2023 Week 09 | Power BI: Create a table with custom and built-in microcharts Read More
2023 Week 08 | Power BI: Create an interactive resume
Introduction Welcome back to Workout Wednesday! This week we will use Power BI to build an interactive resume. This challenge is for a few different audiences. 1) Job seekers – feel free to use this template, plug in your information, make design tweaks, and post this to your portfolio! 2) Data vizzers – use the starter …
2023 Week 08 | Power BI: Create an interactive resume Read More
2023 Week 07 | Power BI: Non-linear Regression
Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …
2023 Week 06 | Power BI: Create a Calendar Heatmap
Introduction For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. Requirements Create a calendar visual: Show day of the week on rows and week on columns. (Hint: If you get stuck on …
2023 Week 06 | Power BI: Create a Calendar Heatmap Read More
2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart
Introduction Hello and welcome back to Workout Wednesday! If you’re joining us for the first time, be sure to check out our complete list of challenges. This week we’re looking at data from the American Academy Awards, also known as the Oscars. The Oscars are awards for artistic and technical merit for the American film industry …
2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart Read More
2023 Week 04 | Power BI: Mortgage Rates Area Chart
Introduction Hello everyone! I’m excited to have my first challenge of 2023 up and ready for your enjoyment. Last year I got a reputation as providing challenges that were, let’s say….a little on the easier side, so this year I’m just going to own it! I was scrolling Twitter in hopes of finding some inspiration …
2023 Week 04 | Power BI: Mortgage Rates Area Chart Read More
2023 Week 03 | Power BI: Vertical Area Chart
Introduction Howdy All! We’re all topsy-turvey this week turning line charts on their side! ⇩ This weeks challenge was inspired by Nick Desbarats article Are Vertical Line Charts Ever a Good Idea? Can you find some other examples where vertical line charts may be a good idea? ⋟^◕ܫ◕^⋞ Happy Vizzing Requirements Power Query Obtain the voteview_polarization_data.csv …
2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations
Introduction For our second week of Workout Wednesday 2023 Power BI Edition, we are taking inspiration from a recent Washington Post interactive story titled “See just how bad a year it was for your retirement account — and why”. The article looks at the closing price of the S&P 500, comparing the value at the …
2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations Read More