Treemap in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Understanding Treemap Area Representation

You have a treemap visual showing sales by product category. The size of each rectangle represents total sales amount. If the sales for 'Electronics' is twice that of 'Clothing', how will their areas compare?

A Both rectangles will have the same area regardless of sales.

B The 'Electronics' rectangle will be twice as large in area as 'Clothing'.

C The 'Clothing' rectangle will be larger because it has more categories.

D The size depends on the number of products, not sales amount.

💡 Hint

Think about what the size of each block in a treemap represents.

In a treemap, the area of each rectangle is proportional to the value it represents. So if 'Electronics' sales are twice 'Clothing', its area will be twice as large.

❓ dax_lod_result

intermediate

DAX Measure for Treemap Size by Category

Given a sales table with columns Category and SalesAmount, which DAX measure correctly calculates total sales per category for a treemap?

A Total Sales = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales))

B Total Sales = SUMX(VALUES(Sales[Category]), Sales[SalesAmount])

C Total Sales = SUM(Sales[SalesAmount])

D Total Sales = COUNT(Sales[SalesAmount])

💡 Hint

Think about how to sum sales amounts grouped by category.

The measure SUM(Sales[SalesAmount]) sums sales amounts and when used in a treemap with category on axis, it calculates total sales per category.

❓ data_modeling

advanced

Modeling Data for Multi-Level Treemap

You want to create a treemap showing sales by Region and then by City within each region. Which data model setup is best?

A Have a single sales table with columns for Region, City, and SalesAmount.

B Create separate tables for Region and City with no relationships to sales.

C Create a disconnected table for Region and link City to sales.

D Use only a City table and ignore Region for simplicity.

💡 Hint

Think about how treemap groups data hierarchically.

A single sales table with Region and City columns allows the treemap to group sales by Region first, then City, showing hierarchical areas correctly.

🔧 Formula Fix

advanced

Troubleshooting Treemap Showing Incorrect Sizes

Your treemap visual shows all categories with equal size, even though sales differ. What is the most likely cause?

A The category field is not added to the treemap.

B The treemap visual does not support size differences.

C The data source has no sales data at all.

D The measure used is a count of categories instead of sum of sales.

💡 Hint

Check what the measure is calculating.

If the measure counts categories instead of summing sales, each category will have the same count (usually 1), making all areas equal.

🧠 Conceptual

expert

Best Practice for Color Usage in Treemaps

Which color strategy improves accessibility and clarity in a treemap showing product categories with sales values?

A Use a single color hue with varying brightness to represent sales values.

B Use random bright colors for each category without a legend.

C Use red for high sales and green for low sales regardless of categories.

D Use grayscale colors only to avoid distraction.

💡 Hint

Think about how color differences help users understand data clearly.

Using one color hue with brightness variation helps users easily compare values while maintaining color harmony and accessibility.