Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 4 different tables: Location, Product, Year and Sales Fact.
I need to create a nested Matrix as below:
I am able to create Column Level Nesting.
But I am not able to create Row Level Nesting between Location and Product.
Need help in achieving this.
Hi @Anonymous
If you have four tables as mine and create relationships as below
Then you could add columns in matrix visual and get the expected output.
Please find more details in my pbix file.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there any particular property that needs to be set?
I already had joins inplace, but I am not getting the desired output.
Above is the output that I am getting.
Thanks,
Ravin
Hi @Anonymous
The cross filter direction between "Product" and "Sales fact" should be "both" instead of "single".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-juanli-msft ,
I change the cross filter from Single to Both.
But still I am not able to achieve the required nesting.
Is there any other property I need to change or set?
Thanks,
Ravin
Hi @Anonymous
I don't know why it doesn't work on your side.
Could you create a simple test pbix file and share with me?
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |