Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A data analyst is building a Power BI report to track customer feedback sentiment over time. The dataset includes 'Date', 'Customer ID', and 'Sentiment Score' (ranging from -1 for negative to +1 for positive). The analyst wants to create a visual that shows the average sentiment score per month and highlights months where the average sentiment drops below 0, indicating predominantly negative feedback. Which visual type and configuration would best meet this requirement?
- ATable visual with a color scale applied to the sentiment score column.
- BPie chart displaying the overall proportion of positive vs. negative sentiment.
- CStacked bar chart showing counts of positive and negative feedback.
- DLine chart with a constant reference line at 0 and conditional formatting for data points.
Show answer & explanationAnswer & explanation
Correct answer: D. Line chart with a constant reference line at 0 and conditional formatting for data points.
A line chart is ideal for showing trends over time (monthly average sentiment). Adding a constant reference line at 0 clearly marks the threshold, and conditional formatting on the data points or line itself can visually emphasize months where the sentiment falls below this critical value.
Why the other options are wrong
- A. A table visual is good for detail, but less effective for quickly spotting overall trends and specific dips visually compared to a line chart.
- B. A pie chart shows static proportions, not trends over time or specific threshold breaches.
- C. A stacked bar chart would show counts, not an average sentiment score, and isn't ideal for trend analysis.
Line Chart with Conditional Formatting & Reference Line
A visual combination used to display trends over time, mark a significant threshold, and visually alert users when data points cross that threshold.
- Line charts excel at showing time-based trends.
- Reference lines provide a static comparison point.
- Conditional formatting adds dynamic visual cues based on rules.
Memory trick: Sentiment's Line Dips, Red Alert!