2021 Week 8 | Power BI: SWITCH()ing Measures


Thanks to everyone who has ben participating in #WorkoutWednesday – Power BI edition. This week we are going to be diving into switching metrics in your reports using SWITCH() and a slicer. This method can be especially useful when designing reports for mobile use. Toggling between metrics allows you to save real estate on your report and allow users to focus on one metric at a time. See the example report below:


  • Create a report view that allows users to toggle between the metrics Total Revenues, Total Expenses, and Total Profits. 
  • Create a Measures Table that lets you reference these values using the SWITCH() function, which you must use. 
  • Use a horizontal slicer to allow you to toggle between the metrics
  • Make sure users aren’t able to see all three metrics at once – we want users to be able to focus on one metrics at a time. 
  • Formatting is totally up to you! We’ve been loving the creativity that the #WOW2021 community has been producing – keep it coming!


This week uses a data set that breaks down NCAA athletic department expenses and revenues by year. You can get it here at data.world. This view is a summarized view that is similar to data used in the first few challenges, but it’s not the same. 


After you finish your workout, share on Twitter using the hashtags #WOW2021 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd and @dataveld. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year. 


4 thoughts on “2021 Week 8 | Power BI: SWITCH()ing Measures”

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top