Forum Discussion
Request for Assistance - Power BI Filter Behavior
Hi prasoonY ,
I suggest you use the star schema (a central table with several lookup tables), cross filtering both directions works well for this schema, refer to the document:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for reply ..
But my problem was i have 4 filter partner ,facility ,affiliate and clerk .
So i select partner then behalf of partner show all facility. then select facility then behalf of facility show affiliate same on affiliate show clerk . this process work now i have one datatable all the records on this table .
if my data fillter on next filter . for example i select facility then data show affiliate .
so how to find data if i select facilty then data show only facility.
Hi prasoonY ,
I suggest you use the star schema (a central table with several lookup tables), cross filtering both directions works well for this schema, refer to the document:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank You