Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |