March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
HI,
i have multiple user and depends on the role i want to show some columns or others (a dynamic table depend on a if )
example
table 1
column a, column b, column c, clumn d, column e.
roles
1
2
new calculate table
if( roles = 1 then (create table with columns 'table1' column a, column d, column e ) else if(roles = 2 then (create table with columns table1 column a, column b, column c) else blank
Regards
Solved! Go to Solution.
Hi @santiagomur
Please kindly check whether you'd like to get below results:
1. I created a Table with column A&B&C&D&E, and another table with only one column as slicer:
2. Then use below measures to generate the output
field1 = SWITCH([Selected],"1",Max('Table'[B]),"2",Max('Table'[D]))
field2 = SWITCH([Selected],"1",Max('Table'[C]),"2",Max('Table'[E]))
Hi @santiagomur
Please kindly check whether you'd like to get below results:
1. I created a Table with column A&B&C&D&E, and another table with only one column as slicer:
2. Then use below measures to generate the output
field1 = SWITCH([Selected],"1",Max('Table'[B]),"2",Max('Table'[D]))
field2 = SWITCH([Selected],"1",Max('Table'[C]),"2",Max('Table'[E]))
Hi @santiagomur ,
assuming you want to display this table of yours in the report canvas, you can't change the columns based on user id. You can try to use measures to show different values for each role, but you will not be able to change column names.
Or have different pages in your report, for each of your roles.
Cheers,
Sturla
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |