How to show particular columns to some users and all columns to other users in Power BI?

[Anonymous]

Hi Team,

Greetings!!

I need to show 3 out 5 columns  to a particulat set of users and all the columns to other user in Power BI. How can I achieve this?

A              B             C              D               E

12	12	23	45	21
12	41	12	64	23
32	12	12	23	43
34	31	43	12	56

Columnc A, B and C should  be visible to user KIOU.
Columns A, B, C, D, E and F should be visible to user JIAN.

Can the concept of Role level that can be  used in this case?
Any help would be highly appreciated.

Thanks,

Anish  

[v-yuta-msft · Accepted solution]

@Anonymous ,

I'm afraid hide column for different users can't achieve your requirement, as a workaround, you may follow steps below:

Click query editor-> Transform-> Unpivot then you will achieve two columns [Attribute] and [Value], after applied&close, you can create two role, one role using dax function:

Table[Attribute] = "A" || Table[Attribute] = "B" || Table[Attribute] = "C"

Then create another role using dax function

Table[Attribute] = "A" || Table[Attribute] = "B" || Table[Attribute] = "C" || Table[Attribute] = "D" || Table[Attribute] = "E" || Table[Attribute] = "F"

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.