Dynamic column header in Power BI using formula or expression

[sunilshewale45]

In existing power BI version we can only rename or hard code column header. request you yo please provide dynamic column header functionality. For example, If we need to populate column header using some formula or expression then it's not possible in power BI.

[rob_solfest1]

This capability is needed to allow for a calculated column to display data from other columns that may be conditionally displayed in a table. An example is a customer list with columns specific to one reseller. When one selects a different reseller, the table can display different values in these custom fields (This solution could be leveraged for reports using Row-Level Security). Within Power BI today this custom column solution can be implemented on a table with calculated columns that will conditionally display the correct row values. However, it does not provide any method to descriptively label the headers of these custom columns. By enabling a dynamic or calculated header label, the custom column's header can display a proper label to describe the data visible in the calculated column instead of just a generic "Column 23" label. Thanks for your consideration!

[rob_solfest1]

It looks like the following ideas could be combined and perhaps higher votes. Please consider voting for multiple of these until they are consolidated... + Dax calculated measure name / Dynamic column headers https://ideas.powerbi.com/ideas/idea/?ideaid=15baaa8c-5cb2-4962-90c8-01b2ecfb358a + Dynamic column header in Power BI using formula or expression https://ideas.powerbi.com/ideas/idea/?ideaid=d388d4f7-2eb4-4791-818c-9b8da6a27183 + Dynamic Column Headers in Table/Matrix https://ideas.powerbi.com/ideas/idea/?ideaid=8d4b32ae-f572-eb11-8ced-0003ff454088

[Bruno_Zambetti]

please use https://ideas.powerbi.com/ideas/idea/?ideaid=15baaa8c-5cb2-4962-90c8-01b2ecfb358a, more votes for this idea

[Alexander_Wodts]

I often use a switch statement to display e.g. budget or previous year in a table compared to actual. It would be great if the column header would change the name.

[peter_carty1]

Dynamic naming of columns would make the user experience better

[par_adeen]

Just got the same customer request today, i.e. to show different column headers based on a filter (dropdown filter) settings.

I tried to overcome using field parameters but they I will have all field parameter columns shown when no selection is done

I also tried using bookmarks and show different visuals but that didn't work either since the filter needs to be a dropdown filter

This should be quite a simple change I would say. No need to advertise it using the function (fx) icon either, a right click on the measure will also work