Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from …
Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you …
2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More
Introduction The April 2023 release of Power BI Desktop gave us dynamic format strings for measures. While the end result could be previously accomplished by using calculation groups, we can now have measures with different formats based upon various conditions – no need to go into Tabular Editor to do this now! While we can …
2023 Week 16 | Power BI: Measure Format Strings and Conditionally Formatted Titles Read More
Introduction Welcome back to Workout Wednesday! This week we’re using a Makeover Monday dataset that was inspired by Andy Kriebel’s post on Twitter (dataviz inception!). Andy has been working through Makeover Monday challenges in Power BI, and I thought it would be a good opportunity for us to do some of these together! This week’s challenge uses what-if parameters, a …
2023 Week 15 | Power BI: What-if parameters inspired by Makeover Monday Read More
Introduction This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US. Requirements Power Query Obtain the dataset from https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html OR https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings Transform and load data HINT : Add Index column, create modulo column, unpivot data Power BI Desktop Obtain Word Cloud custom visual from …
Introduction This week we are getting a bit artistic and taking inspiration from a visual that was recently published by Robin Rohwer on Twitter. She created a connected scatterplot that uses a flower emoji to represent each point. I thought her visual was wonderful, so I set out to create something like it in Power …
2023 Week 13 | Power BI: Create a connected scatterplot with image markers Read More
Introduction Welcome back to Workout Wednesday! This week we’re taking a note out of Meagan’s book and looking at existing reports to ensure they’re accessible to our end-users. Creating accessible Power BI reports isn’t just a nice-to-have feature, but a crucial aspect for ensuring all users can access and understand your data. Don’t let accessibility …
2023 Week 12 | Power BI: Are your reports accessible? Read More
Determining trend for use in smart narratives with DAX LINEST and Power BI
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
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
