PL-300 Question #120: Real Exam Question with Answer & Explanation

Question

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?

Options

• Ano impact
• Bhighlight
• Cfilter

Explanation

Power BI offers three visual interaction modes: Filter (shows only data for the selected segment), Highlight (dims non-selected data while keeping the full bar visible, showing both total and the segment's portion), and No Impact (column chart ignores the selection entirely). The requirement is to see 'which portion of the total sales for the month belongs to the customer segment' - this means both the total and the segment share must be visible simultaneously. Highlight achieves exactly this by overlaying the segment's contribution on top of the full monthly bar. Filter would remove all other data from view, making it impossible to compare the segment's portion against the total.

No community discussion yet for this question.