Forum Discussion
Tree Map
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?
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.
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
3 Replies
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.
Hi thanks for the suggestion,
I am presented with the following error thoughHi thanks for this suggestion,
When I do this it provides me with the following error.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
