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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
bheepatel
Resolver IV
Resolver IV

Dynamic Column Names & RLS

Hi everyone,

 

We have a dashboard which multiple clients use and we make use of RLS to ensure a client can only see their own data.

 

The input data for the dashboard has certain columns that are the same across clients, but certain columns that are different. Below is an example of such, where both Client A and B have a Spend ($) column, but the Region and Product Type columns are different.

 

Client IDSpend ($)Region
A1000USA
A2000UK
A3000AUS

 

 

Client IDSpend ($)Product Type
B2000Shoes
B3000Apparel
B4000Accessories

 

Currently, we have merged the two tables as follows:

 

Client IDSpend ($)Custom Field 1
A1000USA
A2000UK
A3000AUS
B2000Shoes
B3000Apparel
B4000Accessories

 

Is there a way to dynamically rename the column based on the Client ID? So if Client A is looking at the dashboard, they would see "Region" and Client B would see "Product Type" instead of "Custom Field 1".

 

Currently we are using pivoting and the matrix table visual but it is not the best workaround. The ideal solution would be to rename the column headers dynamically.

 

Any help would be much appreciated!

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi  @bheepatel 

Dynamic Column Names could not achieve in power bi for now, the best workaround is unpivot table and use matrix visual to get it.

 

Regards,

Lin

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

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi  @bheepatel 

Dynamic Column Names could not achieve in power bi for now, the best workaround is unpivot table and use matrix visual to get it.

 

Regards,

Lin

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

Thanks @v-lili6-msft 

 

Would you happen to know if dynamic column header is in the pipeline of features to be added in the future?

amitchandak
Super User
Super User

@bheepatel , see if you merge this with RLS

 

https://www.youtube.com/watch?v=6jeSIRpjv0M

 

or refer

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=91eecba8-...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.