PL-300 · Question #208
You have a Power Bl report. You have a table named Dalai that contains 10 million rows. Data is used in the following visuals: - A card that shows the number of records - A bar chart that snows…
The correct answer is B. Add a trend line to the scatter plot. Adding a trend line to the scatter plot overlays a statistical regression line that helps users visually identify the overall direction and pattern in the data (e.g., positive/negative correlation), making meaningful patterns easier to spot. This change is scoped only to the…
Question
You have a Power Bl report. You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
- A card that shows the number of records
- A bar chart that snows total transaction amount by territory
- A scatter plot that shows transaction amount and profit amount on the
axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals. What should you do?
Options
- AApply a row filter to the Dalai query in Power Query Editor.
- BAdd a trend line to the scatter plot
- CEnable high-density sampling on the scatter plot
- DAdd a count field of the transaction amount to the size bucket of the scatter plot
How the community answered
(39 responses)- A5% (2)
- B79% (31)
- C3% (1)
- D13% (5)
Explanation
Adding a trend line to the scatter plot overlays a statistical regression line that helps users visually identify the overall direction and pattern in the data (e.g., positive/negative correlation), making meaningful patterns easier to spot. This change is scoped only to the scatter plot visual and does not alter the underlying data or affect the card or bar chart. Option C (high-density sampling) reduces the number of rendered data points and could obscure true patterns. Option A (row filter in Power Query) would affect all visuals including the card and bar chart, violating the constraint.
Topics
Community Discussion
No community discussion yet for this question.