Intermediate

Line chart with vertical reference line

2022 Week 03 | Power BI: Can you visualize percent difference from a selected date?

Introduction This week we are taking a page from the Tableau team and looking at how a metric has changed from the value at a specified reference date.  Requirements Create a line chart showing percent change of the close price from a selected date.  Use a slicer or other visual to allow users to change …

2022 Week 03 | Power BI: Can you visualize percent difference from a selected date? Read More

2021 Week 48 | Power BI: Create a Waffle Chart

Introduction This week we are continuing our design theme and using the waffle chart custom visual.  Waffle charts show progress toward a whole or a target percentage, and can be used as an alternative to bar and/or pie charts. The Waffle Chart custom visual in Power BI allows us to customize the icon (here we …

2021 Week 48 | Power BI: Create a Waffle Chart Read More

2021 Week 45 | Power BI: Create a Custom Navigation Experience

Introduction We hope that you had a lot of fun last week re-designing Spencer’s report! This week we’re also focusing on design and creating a custom navigation experience using bookmarks and buttons.  I am looking for a new place to live and stumbled upon the 2017 State of American Well-Being report. This PDF report details community well-being …

2021 Week 45 | Power BI: Create a Custom Navigation Experience Read More

Power BI report showing Dutch Bros coffee locations within a radius of a selected city

2021 Week 43 | Power BI: Maps with a Distance Radius

Introduction It’s the final week of mapping month! This week we are plotting points on a map within a selected radius. It’s common to want to see locations, such as stores or restaurants that are nearby to a selected location. This week we are exploring one way to do that in Power BI. This involves …

2021 Week 43 | Power BI: Maps with a Distance Radius Read More

2021 Week 37 | Power BI: What-If Parameters

Introduction This week’s Workout Wednesday we will be using “What-If” Parameters to show Top N values based on user selection. What-If Parameters can allow your audience to have more self-service interaction with the dashboard. For this challenge, we will be visualizing the Top N Movies based on Worldwide sales, as well as leveraging conditional formatting to …

2021 Week 37 | Power BI: What-If Parameters Read More

Power BI Magic Tables

2021 Week 33 | Power BI: Create Magic Tables

Introduction Tables, tables, tables…Love them, or hate them, we, Power BI developers, can’t live without them. Our users too. However, who says that we must provide our users with “normal”, old-fashioned tables? This week, with little creativity and magic, we will push table visual experience to a whole new level! The report below shows data about …

2021 Week 33 | Power BI: Create Magic Tables Read More

2021 Week 29 | Power BI: Let’s Watch the Olympics!

Introduction This week we are collaborating with Preppin’ Data to get a close look at the schedule for the 2020 Olympic Games! We’re also collaborating with the Tableau team and we invite you to take a look at both challenges! With the opening ceremony 2 days away, we thought we’d visualize the schedule in our own time zone. We encourage you …

2021 Week 29 | Power BI: Let’s Watch the Olympics! Read More

Power Bi 2021 week 26 showing a histogram with 8 even bins

2021 Week 26 | Power BI: Make a Histogram with Equal Size Bins

Introduction This is our last week using the Nobel Prize data. We are again looking at the age of the laureate when they were awarded the prize. This time we will examine it using a histogram. Histograms measure the distribution of data within defined ranges. So we are calculating age and creating bins of equal …

2021 Week 26 | Power BI: Make a Histogram with Equal Size Bins Read More

2021 Week 25 | Power BI: Unicode Characters

Introduction This week we are building on Meagan and David’s challenges using the Nobel Prize data. We’re also continuing on our customization journey and will have a bit of fun using unicode values. Unicode is a standard numeric value that represents a character, which can easily be transformed into a character in Power BI using a bit …

2021 Week 25 | Power BI: Unicode Characters Read More

Scroll to Top