Power BI User on 22 May 2020 21:20:51
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.
- Comments (6)
RE: Dynamic column header in Power BI using formula or expression
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 doneI also tried using bookmarks and show different visuals but that didn't work either since the filter needs to be a dropdown filterThis 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
RE: Dynamic column header in Power BI using formula or expression
Dynamic naming of columns would make the user experience better
RE: Dynamic column header in Power BI using formula or expression
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.
RE: Dynamic column header in Power BI using formula or expression
please use https://ideas.powerbi.com/ideas/idea/?ideaid=15baaa8c-5cb2-4962-90c8-01b2ecfb358a, more votes for this idea
RE: Dynamic column header in Power BI using formula or expression
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
RE: Dynamic column header in Power BI using formula or expression
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!