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 add context to the text table.

 

The dataset we will be using comes from Wikipedia.

Requirements

  1. Connect to Top 50 highest grossing superhero movies 
  2. Create a new what-if parameter
  3. Add the what-if parameter slicer to the page
  4. Create a bar chart that only shows Top N highest grossing films based on parameter selection,
    • If a user selects 10 then the chart should only show the top 10 highest grossing films in that chart
  5. Create a table that includes the film name, worldwide sales, and a conditional formatting icon that indicates if that row is within the user selection 

       Extra:

  • Add to the Top N Measure a rule to show all values if a user selects 0
  • Add an average line to the bar chart

Dataset

The dataset we will be using comes from Wikipedia.

Share

After you finish your workout, share on Twitter using the hashtags #WOW2021 and #PowerBI, and tag @sqlsekou@JSBaucke@MMarie, @shan_gsd and @dataveldAlso 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. 

Solution

Download the Power BI Desktop File

1 thought on “2021 Week 37 | Power BI: What-If Parameters”

Leave a Comment

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

Scroll to Top