Microsoft Power BI Practice
Assessment Exam Questions &
Answers (Grade A+)
Which type of visualization supports the following:
- filters other visuals on the same report page
- allows users to search for values by which to filter the other
visuals -
correct answer ✅Slicer
Which visualization displays data in two or more dimensions and
cross-highlights with other visuals on the same report page? -
correct answer ✅Matrix
When would you use a ribbon chart? -
correct answer ✅- Show which data category has the highest rank
(largest value)
- Effective at showing rank change, with the highest range (value)
always displayed on top for each time period
You are using Power BI Desktop to edit a stacked column chart that
displays gross sales data with a date hierarchy that contains year,
quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the
year.
, Microsoft Power BI Practice
Assessment Exam Questions &
Answers (Grade A+)
What should you do? -
correct answer ✅In the Visualization pane, remove the year field
from the date hierarchy fields in the X-axis
Which visuals support the conditional formatting functionality? -
correct answer ✅Matrix and Table
You have a bar chart and column chart visual on a report page.
Selecting any column from the bar chart visual filters the column
chart data to less than 1% of its unfiltered value.
Which type of visual interaction should be used when the bar chart
is filtering the column chart to ensure that you can easily see the
data? -
correct answer ✅Filter
You have a visual that is being cross-highlighted.
By default, what data will be displayed in a report tooltip? -
correct answer ✅The filtered (cross-highlighted) data
What is required to sync slicers between report pages? -
correct answer ✅Each slicer must use the same column
Assessment Exam Questions &
Answers (Grade A+)
Which type of visualization supports the following:
- filters other visuals on the same report page
- allows users to search for values by which to filter the other
visuals -
correct answer ✅Slicer
Which visualization displays data in two or more dimensions and
cross-highlights with other visuals on the same report page? -
correct answer ✅Matrix
When would you use a ribbon chart? -
correct answer ✅- Show which data category has the highest rank
(largest value)
- Effective at showing rank change, with the highest range (value)
always displayed on top for each time period
You are using Power BI Desktop to edit a stacked column chart that
displays gross sales data with a date hierarchy that contains year,
quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the
year.
, Microsoft Power BI Practice
Assessment Exam Questions &
Answers (Grade A+)
What should you do? -
correct answer ✅In the Visualization pane, remove the year field
from the date hierarchy fields in the X-axis
Which visuals support the conditional formatting functionality? -
correct answer ✅Matrix and Table
You have a bar chart and column chart visual on a report page.
Selecting any column from the bar chart visual filters the column
chart data to less than 1% of its unfiltered value.
Which type of visual interaction should be used when the bar chart
is filtering the column chart to ensure that you can easily see the
data? -
correct answer ✅Filter
You have a visual that is being cross-highlighted.
By default, what data will be displayed in a report tooltip? -
correct answer ✅The filtered (cross-highlighted) data
What is required to sync slicers between report pages? -
correct answer ✅Each slicer must use the same column
