Why choosing the right visual matters in Power BI - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Choosing the best visual for comparing categories

You want to compare sales amounts across different product categories clearly and quickly. Which visual type is best to show this comparison?

A A bar chart showing sales amount per category

B A pie chart showing sales percentage per category

C A line chart showing sales amount over time

D A scatter plot showing sales amount vs. product price

💡 Hint

Think about which visual makes it easiest to compare values side by side.

A bar chart is best for comparing amounts across categories because it shows exact values side by side. Pie charts show parts of a whole but are harder to compare precisely. Line charts show trends over time, and scatter plots show relationships between two numeric variables.

❓ dax_lod_result

intermediate

Calculate total sales for the latest year

Given a sales table with a 'Year' column and 'SalesAmount' column, which DAX measure correctly calculates total sales for the latest year in the data?

Power BI

Total Sales Latest Year = CALCULATE(SUM(Sales[SalesAmount]), Sales[Year] = MAX(Sales[Year]))

A CALCULATE(SUM(Sales[SalesAmount]), Sales[Year] = MAX(Sales[Year]))

B SUMX(FILTER(Sales, Sales[Year] = MAX(Sales[Year])), Sales[SalesAmount])

C SUM(Sales[SalesAmount])

D CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[Year]))

💡 Hint

Use a filter to select only the latest year based on the data.

Option A correctly filters sales to only the rows where Year equals the maximum Year in the table, then sums SalesAmount. Option A tries to do the same but MAX(Sales[Year]) inside FILTER is not evaluated correctly row-wise. Option A sums all sales without filtering. Option A removes filters on Year, summing all years.

❓ visualization

advanced

Identify the best visual for showing sales trend and category share

You want to create a dashboard showing both the sales trend over time and the share of sales by category for the latest month. Which combination of visuals is best?

A A table for sales trend over time and a line chart for category share in the latest month

B A line chart for sales trend over time and a pie chart for category share in the latest month

C A scatter plot for sales trend over time and a donut chart for category share in the latest month

D A bar chart for sales trend over time and a stacked bar chart for category share in the latest month

💡 Hint

Think about which visuals best show trends and parts of a whole.

A line chart is ideal for showing trends over time because it clearly shows changes. A pie chart effectively shows parts of a whole, like category share for a single month. Bar charts are less effective for trends, scatter plots are for relationships, and tables are less visual.

🔧 Formula Fix

advanced

Fix the DAX measure that returns incorrect total sales

This DAX measure is supposed to calculate total sales for the current year, but it returns the total for all years. What is the problem?

Total Sales Current Year = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Year] = YEAR(TODAY())))

Power BI

Total Sales Current Year = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Year] = YEAR(TODAY())))

A Change YEAR(TODAY()) to MAX(Sales[Year])

B Use ALL(Sales) inside FILTER to remove filters

C Replace FILTER with Sales[Year] = YEAR(TODAY()) directly inside CALCULATE

D Remove CALCULATE and use SUM(Sales[SalesAmount]) only

💡 Hint

CALCULATE can filter columns directly without FILTER function.

Using FILTER inside CALCULATE applies a row context that may not behave as expected. Replacing FILTER with a direct filter condition Sales[Year] = YEAR(TODAY()) inside CALCULATE applies the filter correctly. Option C adds ALL which removes filters, option C changes logic, and option C removes filtering.

🎯 Scenario

expert

Design a dashboard for multiple user roles with different data needs

Your company has sales managers and finance analysts. Sales managers want to see sales trends and top products, while finance analysts want detailed profit margins and cost breakdowns. How should you design the Power BI dashboard to meet both needs effectively?

A Create dashboards only for sales managers and share raw data with finance analysts

B Create a single dashboard with filters to switch between sales and finance views

C Create one dashboard with all visuals for both roles combined

D Create separate dashboards for sales managers and finance analysts with tailored visuals

💡 Hint

Think about user focus and clarity of information.

Separate dashboards tailored to each role ensure users see only relevant information, improving clarity and usability. Combining all visuals can overwhelm users. Filters can help but may complicate navigation. Sharing raw data is not user-friendly for finance analysts.