Tree Map

[andykbba]

Hi all,

I have some general Australian Bureau of Statistics Data. 

Essentially I have the location of a place in Australia (in one column)

And 19 other columns which show how many people in Australia work in one particular area of employment. 

When i create a treemap it looks overly clustered as it is trying to fit all 19 industries of employments in. 

I have a slicer which can be applied to produce the results for each postcode and the industries of employment vary depending on what is most popular in each area. 

How do i apply a limitation/filter to only show the top 5 industries of employment in the tree map? 

[Ritaf1983 · Accepted solution]

Hi @andykbba 
You need to unpivot your table to get the form:

Then you can use the top n filter.

Guide to unpivot :

https://www.youtube.com/watch?v=T8Ekr_sLP-0

Filtering by top n:

https://www.youtube.com/watch?v=4N-KocuYyNU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[andykbba]

Hi thanks for the suggestion,

I am presented with the following error though

Hi thanks for this suggestion, 

When I do this it provides me with the following error. 

[Ritaf1983 · Accepted solution]

Hi @andykbba 
The error message says that you used the column that you need to unpivot as the primary key to create a a relationship, which is not efficient practice.

 You need to create another table with unique values of this column and use it to create relationships.
For more information please refer :

https://www.seerinteractive.com/insights/join-many-many-power-bi

(this is a more detailed explanation of bridge tables)

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

this is about modeling

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @andykbba 
You need to unpivot your table to get the form:

Then you can use the top n filter.

Guide to unpivot :

https://www.youtube.com/watch?v=T8Ekr_sLP-0

Filtering by top n:

https://www.youtube.com/watch?v=4N-KocuYyNU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.