Introduction This week we are continuing our design theme by working through a custom formatting hack for line charts. Conditional formatting in Power BI can be tricky at times, especially when trying to format different chart types. If you are familiar with conditionally formatting a line chart, you’ll know that in the Data Colors section …
2021 Week 47 | Power BI: Custom Line Chart Formatting Read More »
Introduction We hope that you had a lot of fun with our mapping month in November where we focused a lot on maps and geospatial data in our challenges. This week we are going to be shifting gears and focusing on report design. This week your challenge is to take a report that already has …
Introduction Welcome to week 3 of mapping month! The Workout Wednesday Power BI team is focusing on maps and geospatial data in Power BI. There are several different maps available in Power BI as default and custom (AppSource) visuals. Last week we explored how to implement custom maps from Mapbox into Power BI. This week we …
Introduction It can be challenging getting a new dataset and quickly finding something to focus on and tell a story about. Power BI has built in tools that help you quickly identify data points of interest, and provides visuals that can help tell the story. Have Power BI help you tell the story with your …
2021 Week 39 | Power BI: Assist Your Data Exploration with AI Read More »
Introduction This week we are going to be exploring how to use Bookmarks to toggle between different views in a report. There are a number of things you can do with Bookmarks, but in this week’s example we are going to use them to toggle between chart views and then as a Reset Filters button. …
2021 Week 32 | Power BI: Toggling Views with Bookmarks Read More »
Introduction Over the course of Power BI’s Workout Wednesday challenges, you’ve had a chance to try several “custom” visuals. These are typically developed by third parties and may or may not appear on Microsoft’s AppSource marketplace. Generally, you don’t have much control over the visualization apart from whatever format options the developer creates. This week, …
2021 Week 31 | Power BI: Declarative Visualization with Deneb Read More »
Introduction Continuing with the Nobel Prize data that Meagan began exploring last week, this week extends to consider aspects of individual Nobel laureates. The main visual is a cumulative line chart, but you’ll also provide detail on laureates with a report page tooltip. While additional JSON expansion and transformation was required from the original dataset, …
2021 Week 23 | Power BI: Can You Build a Cumulative Line Chart? Read More »
Introduction It’s week 17 and we’re back to create what demographers refer to as an Age Pyramid, in which each bar represents the makeup of the US population as a whole in 5 year cohorts. The inspiration for this visual came from the Pew Research Center’s 2014 publication in which they visualized “America’s Morphing Age …
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Introduction Thanks to everyone who participated in the first month of #WorkoutWednesday – Power BI edition. If you are joining us for the first time this week, welcome to week 5! We’ve got a new dataset and a fun new challenge! Last week you learned how to use the powerful drill-through feature. This week we’ll focus on …
