topic Re: Hidden column in condition to create new dimension in DAX Commands and Tips

Hidden column in condition to create new dimension

Anonymous — Wed, 18 Oct 2023 10:45:08 GMT

Hi All,

I have applied OLS on column through tabular editor. There are few columns which should be hidden for some roles. But actually that column is used as dimension of graph (other users have access to that column). What I want is if user for which that column is hidden, I want to show other colum as dimension in same graph. Is there a way to create conditional dimension in grpah like, if(ColumnHidden, ShowOtherCoumn, SameColumn_Not_Hidden_for_other_user)?

Re: Hidden column in condition to create new dimension

kushal_chawda — Wed, 18 Oct 2023 14:20:52 GMT

Anonymous There could be other way around but I can think of below which is not straightforward

1) You need to create UserDetails table with UserName and DisplayCoulumn. UserName will be email address which could be referenced by USERPRINCIPALNAME(). DisplayColumn will capture the name of the column you want to display for that user. eg. you table would look like below. 'TableName' will be name of your data table where dimensions are stored.

UserName	DisplayColumn
user1@abc.com	'TableName'[Column1]
user2@abc.com	'TableName'[Column2]

2) Create Dynamic RLS Role using Manage Role from Modelling tab. Apply filter condition on UserDetails table as below for that role
[UserName] = USERPRINCIPALNAME()

3) Create DAX measure as below to capture the name of the column for that user.
DynamicColumn= VALUES(UserDetails[DisplayColumn])

4) Create a Dimension parameter with any dimension and then update the parameter as below to include DAX measure which will capture dynamic column name
Dimension -Parameter = {
("Column Name", [DynamicColumn], 0)
}

5) Call the Dimension - Parameter in your chart as dimension.

Re: Hidden column in condition to create new dimension

Anonymous — Wed, 25 Oct 2023 13:52:50 GMT

kushal_chawda thanks but it doesn't work

Re: Hidden column in condition to create new dimension

Anonymous — Wed, 25 Oct 2023 13:53:26 GMT

amitchandak marcorusso can you help?

Re: Hidden column in condition to create new dimension

Anonymous — Tue, 31 Oct 2023 10:03:17 GMT

No one has any solution?