Power BI Report with tree map visualization

We have SharePoint online list with three lookup column ex Country, State and district and having two column with Government office and Private office. Based on this wanted to develop the report in Power BI as per below format

India(Level 1)
	Maharashtra(Level 2)	2
		Mumbai(Level 3)
		4

Count 2 represent no of gov office and count 4 represent no of private office

I tried with Tree map visualization but at level three instead of data I am getting count, which I don’t want

Questions:

How to display actual level three data in report
Is it possible to apply color code conditional formating for Tree map visualization, is yes then how to apply please let me know.

Tree Map in Power BI, by default, shows the size of each box based on aggregated numeric values (like count, sum...), and displays the category label (like district name), but you might be seeing aggregated counts as labels instead of actual names.

In Power BI Fields pane, right-click the column for Country and choose “New hierarchy”

Add State and District fields under this hierarchy.

Then drag the District field (or the entire hierarchy) to the Group field well and drag Gov Office Count (or a calculated measure/column) to the Values well.

If you want to display the district names inside the tree map tiles (instead of just numbers), Power BI should do that by default if the number of tiles isn’t too many. If you're seeing just the count, it could be because the visual is too small, or the same value is repeated (multiple Mumbais across different states).

You can apply conditional color formatting in a Tree Map.

Click on the Tree Map visual.
In the Visualizations pane, click on the Format (paint roller) icon.
Expand Data colors.
Click the fx button next to "Default color".
A dialog will pop up to define conditional formatting:
- Choose a field to base the formatting on — Gov Office Count or Private Office Count.
- Select a color scale or custom rules based on your values.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi1y ago
Tree Map in Power BI, by default, shows the size of each box based on aggregated numeric values (like count, sum...), and displays the category label (like district name), but you might be seeing aggregated counts as labels instead of actual names.

In Power BI Fields pane, right-click the column for Country and choose “New hierarchy”

Add State and District fields under this hierarchy.

Then drag the District field (or the entire hierarchy) to the Group field well and drag Gov Office Count (or a calculated measure/column) to the Values well.

If you want to display the district names inside the tree map tiles (instead of just numbers), Power BI should do that by default if the number of tiles isn’t too many. If you're seeing just the count, it could be because the visual is too small, or the same value is repeated (multiple Mumbais across different states).

You can apply conditional color formatting in a Tree Map.
- Click on the Tree Map visual.
- In the Visualizations pane, click on the Format (paint roller) icon.
- Expand Data colors.
- Click the fx button next to "Default color".
- A dialog will pop up to define conditional formatting:
  
  Choose a field to base the formatting on — Gov Office Count or Private Office Count.
  
  Select a color scale or custom rules based on your values.