Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have say 4 tables Sales register,purchase,salary,production i have data in day basis in some table and month basis in some table so i have created month column in all table and trying to build relationship with month i also have status column in all table except production so also bulding relationship with that too .... i am facing some problem over relations like if i filter on date it is working fine even status is working fine but some filter i have from sales register affecting charts of other table that have no relation with sales i am not sure why filters are working on wrong visual .
I am not sure why filter name of item affecting salary distibution table where logicaly it has nothing to do with sales item to that of salary distribution likly it is affecting prodiction table visul as slary and production shareing same date for some visuals
Solved! Go to Solution.
see if you can classify your tables as dimension tables or fact tables. How do they control each other?
Ideally you have a star schema with 1:* single direction relationships.
You may want to add a calendar table to your data model.
yes i have tried and i have externally risticted working of some flter on some visuls so now it is working fine for me Thanks
see if you can classify your tables as dimension tables or fact tables. How do they control each other?
Ideally you have a star schema with 1:* single direction relationships.
You may want to add a calendar table to your data model.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
4 | |
3 | |
3 | |
2 |