Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium

Question 10

Given below is an organization’s sales report for the last financial year.



Which of the following actions would you take to point out sales trends and highlight key takeaways from the entire report? You should be able to slice and dice the resulting information from any existing report visual.

  • A

    Use the Power BI Q&A feature

  • B

    Add a trendline

  • C

    Right-click on a visual and click Summarize

  • D

    Use smart narrative visual

Reveal correct answer

Correct answer: D

Explanation

When you right-click on a visual and click Summarize, Power BI creates a new smart narrative visual that provides a quick summary of the visual. But the trends and the key takeaways are limited only to the visual, not the entire report.



Reference Link: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative#smart-narrative-for-a-visual

Option B is incorrect.


To point out sales trends and highlight key takeaways for the entire report, use the smart narrative visual.



Reference Link: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative#smart-narrative-for-a-page


You can slice the smart narrative visual by any other report visual. The smart narrative visual updates to display the information specific to the chosen field. For example, below we slice the visual by the Technology category (from the pie chart).



Option C is the correct answer.


We add a trendline to a specific visual, for example, a clustered column chart to capture the trend. Trendlines do not highlight trends for an entire report.



The output expected from the question is some kind of text information. Option A is incorrect.

Reference Link: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane


Power BI Q&A is a natural way to interact with your data and create report visuals. Smart narratives are more suited to the given objective. Option D is also incorrect.

Reference Link: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-tutorial-q-and-a?tabs=powerbi-desktop

PBIX File Link: Sales trends and highlight key takeaways

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need