Forum Discussion
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
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.
Super UserHi 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