This Power BI Online Test
Separates Good From Bad Hires
Check our public questions below
Solve questions to get feedback or
take a practice test and get a free certificate.
Screen with work-sample questions
Work-samples are the best predictor of work performance. 8,000+ companies use TestDome premium questions.
About the test
The Power BI developer online test assesses candidates' knowledge of creating Power BI reports.
It’s an ideal test for pre-employment screening. A good Power BI developer needs to be able to not only know how to correctly configure charts, but also know how to use Power Query to clean the data and use DAX for creating advanced reports.
This online test requires candidates to answer multiple-choice and fill the blanks questions about Power BI.
Sample public questions
A business owner needs a Power BI report which shows the projected quantity for each item. The "quantity" column is in the "items" table.
Fill in the blank of the following DAX expression for a new column that will compute the projected quantity, which is the current quantity plus 12%:
Projected Quantity = ______________ * 1.12
As an entry-level financial analyst, your manager asked you to analyze the prices of a new stock and make a buy-sell recommendation. Daily price trends seems to fluctuate as can be seen below:
You need to create a new measure which will create a rolling average for 7-day periods, as below, because an increasing trend in a rolling average may signal an increase in the price of the stock.
How should you configure the quick measure, shown below, for the rolling average for the last 7 days?
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.
For companies: premium questions
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
13 more premium Power BI questions
Query Join, Sales per Product, Sale Discount, Modifying Profit, Average Sales, Profit Chart, Regional Report, Device Purchases, Net Adds, Grocery Sales, Book Sales, Beverage Sales, Marketing Performance Report.
Skills and topics tested
- Power BI
- Power Query
- Matrix Visualization
- Chart Configuration
- Data Modeling
- Performance Tuning
- Data Cleaning
- Data Aggregation
- Bug Fixing
- Row-Level Security
For job roles
- Data Analyst
- Power BI Analyst
- Power BI Developer
Sample candidate report
What others say
Simple, straight-forward technical testing
TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.
Jan Opperman, Grindrod Bank
Solve all your skill testing needs
150+ Pre-made tests
From web development and database administration to project management and customer support. See all pre-made tests.
Mix questions for different skills or even custom questions in one test. See an example.
How TestDome works
Choose a pre-made test
or create a custom test
Invite candidates via
email, URL, or your ATS
a test remotely
Sort candidates and
get individual reports