Power BI Exam UPDATED Exam Questions
and CORRECT Answers
funnel - CORRECT ANSWER - displays a linear process with sequentially connected
stages, with one stage transitioning to the next.
slicer - CORRECT ANSWER - available in different formats, including list, drop-down,
and buttons, but not sequentially connected stages, with one stage transitioning to the next
treemap - CORRECT ANSWER - displays data as a set of nested rectangles
waterfall - CORRECT ANSWER - displays a running total as values are added or
subtracted
matrix - CORRECT ANSWER - displays data in two or more dimensions and cross-
highlights with other visuals on the same report
card - CORRECT ANSWER - displays a single data point
scatter - CORRECT ANSWER - a chart, not a grid. It has two value axes, with one set of
numerical data along a horizontal axis and another set of numerical values along a vertical axis
table - CORRECT ANSWER - a grid that contains related data in a grid format, with
support for two dimensions only
Install R on your computer - CORRECT ANSWER - You need to create a custom R visual
by using Power BI Desktop. What do you need to do first?
-Configure global R scripting options in Power BI Desktop
-Enable preview features in Power BI Desktop
,-Enable the script visuals option in the Visualization pane of Power BI Desktop
-Install R on your computer
filter, highlight - CORRECT ANSWER - You are editing a report in Power BI Desktop.
You need to adjust the behavior of the report by editing interactions. Which two types of
interaction behavior can you change between visuals?
drillthrough, expand, filter, highlight
Disable the Data option, disable the Current Page option, and Enable the Display option -
CORRECT ANSWER - You need to create a bookmark that toggles the visibility of a
visual. This bookmark must only toggle the visibility state and perform no other action. Which
three configurations should you make?
-Disable the Data option
-Disable the Current Page option
-Disable the Display option
-Enable the Current Page option
-Enable the Data option
-Enable the Display option
Hide three cards in the Selection Pane - CORRECT ANSWER - You are modifying a
report in Power BI Desktop. The report contains a single report page that has three card visuals
and one clustered bar chart. You need to create a bookmark that displays only the clustered bar
chart and hides the cards. What should you do first?
-Add a bookmark in the Bookmarks Pane
-Hide three cards in the Selection Pane
-Publish the report to the Power BI Service
-Select the Spotlight option on the clustered bar chart
, -Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
-Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
-Use conditional formatting to set the button text - CORRECT ANSWER - From Power BI
Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-
time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
The navigation destination must change based on the output of a DAX measure named [Error
Rate].
If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to
the Error Rate page.
Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate
page.
What three actions should you perform?
-Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
-Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
-Set the button type to Bookmark and then use conditional formatting to specify the destination.
-Set the navigation destination to the Error Rate page.
-Use conditional formatting to set the button text.
In the Visualizatoins pane, remove the year from the date hierarchy fields in the X-axis -
CORRECT ANSWER - You are using Power BI Desktop to edit a stacked column chart
that display 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. What should you do?
-In the Filters pane, add a filter based on the quarter, month, and day.
-In the Filters pane, add a filter based on the year.
-In the Format pane, modify the Maximum Range setting.
and CORRECT Answers
funnel - CORRECT ANSWER - displays a linear process with sequentially connected
stages, with one stage transitioning to the next.
slicer - CORRECT ANSWER - available in different formats, including list, drop-down,
and buttons, but not sequentially connected stages, with one stage transitioning to the next
treemap - CORRECT ANSWER - displays data as a set of nested rectangles
waterfall - CORRECT ANSWER - displays a running total as values are added or
subtracted
matrix - CORRECT ANSWER - displays data in two or more dimensions and cross-
highlights with other visuals on the same report
card - CORRECT ANSWER - displays a single data point
scatter - CORRECT ANSWER - a chart, not a grid. It has two value axes, with one set of
numerical data along a horizontal axis and another set of numerical values along a vertical axis
table - CORRECT ANSWER - a grid that contains related data in a grid format, with
support for two dimensions only
Install R on your computer - CORRECT ANSWER - You need to create a custom R visual
by using Power BI Desktop. What do you need to do first?
-Configure global R scripting options in Power BI Desktop
-Enable preview features in Power BI Desktop
,-Enable the script visuals option in the Visualization pane of Power BI Desktop
-Install R on your computer
filter, highlight - CORRECT ANSWER - You are editing a report in Power BI Desktop.
You need to adjust the behavior of the report by editing interactions. Which two types of
interaction behavior can you change between visuals?
drillthrough, expand, filter, highlight
Disable the Data option, disable the Current Page option, and Enable the Display option -
CORRECT ANSWER - You need to create a bookmark that toggles the visibility of a
visual. This bookmark must only toggle the visibility state and perform no other action. Which
three configurations should you make?
-Disable the Data option
-Disable the Current Page option
-Disable the Display option
-Enable the Current Page option
-Enable the Data option
-Enable the Display option
Hide three cards in the Selection Pane - CORRECT ANSWER - You are modifying a
report in Power BI Desktop. The report contains a single report page that has three card visuals
and one clustered bar chart. You need to create a bookmark that displays only the clustered bar
chart and hides the cards. What should you do first?
-Add a bookmark in the Bookmarks Pane
-Hide three cards in the Selection Pane
-Publish the report to the Power BI Service
-Select the Spotlight option on the clustered bar chart
, -Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
-Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
-Use conditional formatting to set the button text - CORRECT ANSWER - From Power BI
Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-
time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
The navigation destination must change based on the output of a DAX measure named [Error
Rate].
If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to
the Error Rate page.
Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate
page.
What three actions should you perform?
-Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
-Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
-Set the button type to Bookmark and then use conditional formatting to specify the destination.
-Set the navigation destination to the Error Rate page.
-Use conditional formatting to set the button text.
In the Visualizatoins pane, remove the year from the date hierarchy fields in the X-axis -
CORRECT ANSWER - You are using Power BI Desktop to edit a stacked column chart
that display 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. What should you do?
-In the Filters pane, add a filter based on the quarter, month, and day.
-In the Filters pane, add a filter based on the year.
-In the Format pane, modify the Maximum Range setting.
