show selected rows in dropdown (instead of all)

[Anonymous]

Hi! I need help in doing something that sounds easy and simple and I cannot figure it out. So I have a drop down list that takes a column from a table.

My "Products" drop down list takes the column "product_name" from the table dim_products. But this is a prolem because I have a few customers and each one should see only there own products.  I tried to make a relationship between dim_customers and dim_products but got the error: 

any ideas?

Thank you!!

[v-yalanwu-msft]

Hi, @Anonymous ;

If you want to a few customers and each one should see only there own products, perhaps using RLS will be better.

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399

In addition, the error in the figure is because dim_planogram and dim_stores already have relationship. 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.