Filter data to particular user in power bi using RLS

0
votes

Suppose I have a column CATEGORY_NAME in table CATEGORY I want a user named [email protected] to see only ('CPU','Storage','Video Card') values of column CATEGORY_NAME in one power bi application.How can I define roles in powerbi desktop for this user.So they can only see these 3 values in CATEGORY_NAME .

How the Table filter dax expression can be written in manage Roles?

1
powerbipowerbi-desktoprow-level-security

1 Answers

1
votes

This can be donne with this code :

[CATEGORY_NAME] ="CPU"  || [CATEGORY_NAME] ="Storage"  || [CATEGORY_NAME] ="Video Card"