Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JC25
Regular Visitor

Showing different table column name based on viewer roles

I am trying to show different column name for different viewer roles. I have a column in a table named ABC. I want to make it so that when I pick User 1 and User 2, the column header will be ABC, but when I change the viewer role to other roles e.g. User 3 the column header will change to XYZ. Is there a way to do this?

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

Hi @JC25,

 

I think it's possible to solve this problem using field parameters.
1 - Create a field parameter with the two columns that you want.
2 - Add a new column on your usernames/roles table that you are using to apply the RLS and classified each username with the number of the order parameter (created on the first step) according your needed

3 - Link the Parameter table with the usernames/roles table

4 - Use the parameters filed on the matrix instead of the column.

I did a quick example, please take a look:
1 - Field Parameter

_AAndrade_0-1715591130663.png

2 - Add new column

_AAndrade_1-1715591198095.png

3 - Relationship between the two tables

_AAndrade_2-1715591255715.png

4 - Final Output

_AAndrade_3-1715591317364.png

_AAndrade_4-1715591327906.png

I hope this can help you to solve your issue.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

2 REPLIES 2
_AAndrade
Super User
Super User

Hi @JC25,

Could you please tell me if my post solved your issue? If so, could you mark my message as the answer to this problem?
I'd be very grateful. Thank you very much





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Hi @JC25,

 

I think it's possible to solve this problem using field parameters.
1 - Create a field parameter with the two columns that you want.
2 - Add a new column on your usernames/roles table that you are using to apply the RLS and classified each username with the number of the order parameter (created on the first step) according your needed

3 - Link the Parameter table with the usernames/roles table

4 - Use the parameters filed on the matrix instead of the column.

I did a quick example, please take a look:
1 - Field Parameter

_AAndrade_0-1715591130663.png

2 - Add new column

_AAndrade_1-1715591198095.png

3 - Relationship between the two tables

_AAndrade_2-1715591255715.png

4 - Final Output

_AAndrade_3-1715591317364.png

_AAndrade_4-1715591327906.png

I hope this can help you to solve your issue.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.