The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
First I had a flat table and when I filtered in the filters pane, it would also filter out the other 'dimension columns'.
Now I made it into a star schema and when I filter 1 dimension in the filters pane, it doesn't filter the other dimensions. It shows all values in that column. I understand why, but how can I achieve this?
Note: I have multiple fact tables that connect to these same dimension tables. Below is 1 of the star schemas.
Did you ever find a solution for this? I've read much about how one can solve this if using slicers, but nothing about how to solve it when using the filter pane. I've tried many model options and nothing seems to work. Bi-directional ends up with circular references; I'm never working with M:M relationships and don't intend to; etc.
Hi @richard-powerbi ,
If I understood you correctly you should get the relationships both sided.
Let me know if that's what you wanted and if it worked, if so mark as solution.
BR,
DR
I don't think so unless you make some common table that associates all the foreign keys from those all tables.
BR,
DR
So I'm trying to implement this now. Would I have to add the table with only the keys between the fact tables and dimension tables? Or on top of the dimension tables? Could anyone sketch this?
Hi @richard-powerbi ,
How about the result after you follow @Anonymous 's suggestions ?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
I still have to implement this, when I have no other questions I'll accept it as a solution.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
99 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |