JOBSEEKER?

Power BI Interview Questions

Practice for Power BI interviews by solving TestDome questions. Our interview questions are used by more than 7,000 companies and 450,000 individual test takers.

Jobseekers: Certify Your Knowledge

Take a Certification Test

Companies: Use Our Tests for Screening

Buy a Pack Of Candidates

Need to practice your Power BI skills for an upcoming job interview? Try solving these Power BI interview questions that test knowledge of DAX, Power Query, and chart configuration. We’ll provide feedback on your answers, and you can use a hint if you get stuck.

These Power BI interview questions are examples of real tasks used by employers to screen job candidates such as data analysts, Power BI analysts, Power BI developers, and others that need to solve problems using Power BI and it’s rich set of built-in functions.

1. Product Chart

Chart configuration
   
Easy 

A Power BI report for a model which has the Country, Sales, and Product fields should show the following bar chart:

Bar chart of Sale Price by Profit and Product

Select all the things that need to be done to recreate the chart above.

(Select all acceptable answers.)

Add Sale Price as an axis.
Add Country as a value.
Add Sale Price as a value.
Add Product as a value.
Add Country as an axis.
Add Product as the legend.
   


2. Sales Projection

DAX
   
Easy 

​A business owner needs a Power BI report which shows projected sales for the next year. The sales field is in the "reports" table. A sale is represented by the "sales" field. The "reports" table contains only data for the current year.

Fill in the blank of the following DAX expression for a new column that will compute the sales projection as the current year's sales plus 12 percent growth:

Next Year Sale =  * 1.12
   


3. Profit Percentage

DAX Measure
   
Hard 

A Power BI report has a measure declared as:

Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials))

Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis.

(Select all acceptable answers.)

If there are multiple countries, the value of "Profit percentage" for each country will be 1.
If all rows in financials have a Country set, the sum of all "Profit percentage" columns in the chart will be 1.
If some countries are disabled by a page level filter, the value of each "Profit percentage" column will change.
If some countries are disabled by a visual level filter, the sum of all "Profit percentage" columns might not be 1.
   


If you feel ready, take one of our timed public Power BI Interview Questions tests:
Power BI

Power BI Online Test (Easy / Hard)

Not exactly what you are looking for? Go to our For Jobseekers section.
Dashboard Start Trial Sign In Home Tour Tests Questions Pricing For Jobseekers