Introduction
The January 2025 update of Power BI Desktop brought us some enhancements to the tree map visual, including 3 new tiling methods and options for spacing between groups and nodes. So this week we are trying out those features to make a tree map organized into columns.
Requirements
- Download the “Regional Sales Sample.pbix” file from Microsoft’s public Github page. If you cannot access Github, you can download a copy from OneDrive here.
- Create a new report page and remove all existing report pages.
- Add the following measures:
- Pipeline Value is the sum of the value column in the Opportunities table.
- Average Opportunity Value is the average of the value column in the Opportunities table.
- Create a tree map using the core visual.
- Populate the Category with the ‘Opportunities'[Sales Stage] field
- Populate the Details with the ‘Products'[Product Category] field
- Populate the Values with the [Pipeline Value] measure (see #2 above)
- Populate the tooltips with the [Average Opportunity Value] (see #2 above), [Opportunity Count in Pipeline], and [Revenue in Pipeline] measures.
- Format the tree map so that:
- sales stages are represented by columns and product categories by rows
- there is additional space between the sales stage columns
- the pipeline value amount is shown in each tile
Dataset
We are using a Microsoft sample pbix as our dataset. It contains all the tables and relationships required for our challenge.
Download the “Regional Sales Sample.pbix” file from Microsoft’s public Github page. If you cannot access Github, you can download a copy from OneDrive here.
Share
After you finish your workout, share on social media using the hashtags #WOW2025 and #PowerBI.
On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social.