how to apply treemap without a direct relationship between tables power bi

[qoqa89]

"I have a question that I'm struggling with.

As you can see in the images, this data is from AdventureWorks 2019. The relationship between the 'orders' table and the 'products' table is not direct, so when I use a treemap, the number of #orders is the same for all fields, and I want it to change depending on which field the mouse is hovering over.

I would appreciate it if someone who knows the answer could write the steps individually for anyone new to learning Power BI."

[Uzi2019 · Accepted solution]

Hi @qoqa89 

I think you are getting same #order( order table) against all product (product table).

As you can see the relationship between 2 table in one way.  

you can change the relationship by clicking on it > set it to both direction > save

By doing this you data will be filtered based on product value also.you will not get same numbers for product. 

set both the relationship to both direction

I hope I answered your question!

[qoqa89]

It works smoothly. thanks a lot

[Uzi2019]

@qoqa89 
Happy to help!!

[FreemanZ]

hi @qoqa89 ,

what do you mean by "all field", or what columns do you have for the treemap?

[qoqa89]

when you use treemap ex. for categories it will divide into fields depending on the value of each category.
Uzi2019 gave the solution. thank you for being interested.

[qoqa89]

when you use treemap ex. for categories it will divide into fields depending on the value of each category.
Uzi2019 gave the solution. thank you for being interested.