This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Create reports
      --> Format and configure visuals

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

Question 1

A column chart displays revenue by product category, but users want to see the exact revenue values directly on the bars.
What should you configure?

A. Enable the legend
B. Enable data labels
C. Change the chart type
D. Adjust the axis scale

Correct Answer: B

Explanation:
Data labels display exact values directly on the visual, allowing users to see precise figures without hovering.

---

Question 2

A report contains a line chart showing monthly sales, but the values are difficult to interpret because they are displayed as large numbers (for example, 1250000).
What is the best formatting adjustment?

A. Change the visual to a table
B. Apply conditional formatting
C. Set display units to millions
D. Enable tooltips

Correct Answer: C

Explanation:
Using display units such as millions or thousands improves readability while preserving trend interpretation.

---

Question 3

A legend on a stacked bar chart overlaps with data points, making the chart difficult to read.
What is the most appropriate solution?

A. Remove the legend
B. Change the visual type
C. Move the legend position
D. Disable interactions

Correct Answer: C

Explanation:
Repositioning the legend improves readability without removing useful category information.

---

Question 4

A stakeholder wants negative variance values in a table to stand out visually.
Which configuration best meets this requirement?

A. Apply a report theme
B. Sort the table descending
C. Use conditional formatting with color rules
D. Increase font size

Correct Answer: C

Explanation:
Conditional formatting allows you to apply visual cues, such as red coloring, to values that meet specific conditions.

---

Question 5

Two visuals showing sales by region use different colors for the same regions, confusing report users.
What should you do to fix this?

A. Remove one of the visuals
B. Apply consistent category colors
C. Enable data labels
D. Disable cross-filtering

Correct Answer: B

Explanation:
Using consistent colors for the same categories across visuals improves comprehension and reduces confusion.

---

Question 6

A bar chart should display categories ranked from highest sales to lowest sales.
Which setting should you adjust?

A. Axis scale
B. Sort order
C. Data labels
D. Visual interactions

Correct Answer: B

Explanation:
Sorting the visual by the sales measure in descending order ensures categories appear in the correct ranking.

---

Question 7

A KPI visual should clearly indicate whether performance meets a target.
Which configuration best supports this requirement?

A. Add a legend
B. Enable conditional formatting
C. Change font type
D. Adjust background transparency

Correct Answer: B

Explanation:
Conditional formatting helps visually distinguish between values that meet or miss targets, improving quick interpretation.

---

Question 8

A report consumer wants to see percentage values instead of decimals (for example, 0.25 instead of 25%).
Where should this formatting be applied?

A. In the visual’s title settings
B. In the axis settings
C. In the field’s number formatting
D. In the report theme

Correct Answer: C

Explanation:
Number formatting for fields controls how values such as percentages and decimals are displayed across visuals.

---

Question 9

Selecting a bar in one visual highlights related data in another visual, but users want the second visual to filter instead of highlight.
What should you configure?

A. Drill-through settings
B. Sorting behavior
C. Visual interactions
D. Legend position

Correct Answer: C

Explanation:
Visual interactions control whether visuals filter, highlight, or ignore selections from other visuals.

---

Question 10

Which principle should guide all formatting and configuration decisions in Power BI visuals?

A. Use as many formatting options as possible
B. Match the formatting used in other reports exactly
C. Improve clarity and accuracy for the end user
D. Make visuals visually impressive

Correct Answer: C

Explanation:
Formatting should always support clear, accurate communication of insights, not aesthetics or complexity.

---

Go back to the PL-300 Exam Prep Hub main page