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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Dax calculated measure name / Dynamic column headers

Dax Measure names are currently static and when added to a table or matrix there is no way to dynamically change the measure or column name. using SELECTEDVALUE a user is able to change the context of a measure to show for example Actuals, Budget or Forecast but the measure name remains static. This is not very user friendly since we are not providing the end-user with a clear context if the measure can be modified by SELECTEDVALUE but the measure name does not provide a matching context. If the measure name or column name had the ability to be calculated in a similar fashion, Power BI developers would have the ability to dynamically change the display name accordingly and create a smooth and dynamic user experience. Dynamic column names are available both in Qlik products and Tableau and would be an extremely useful feature to have in Power BI!
Status: Needs Votes
Comments
agurov
New Member
Perhaps this could be achieved by assigning an ALIAS to the measure field
pbiideas1
New Member
This will immensely help us. There is no way for us to show dynamic headers and clients have been requesting this from us for a while now.
fbcideas_migusr
New Member
As someone who uses dynamic columns constantly, this would be a huge step forward. My users are likely getting tired of seeing columns named "Selected Metric", etc.
deran_naidoo
New Member
Such a basic yet extremely powerful piece of functionality. This would be a huge win if this were to be implemented in Power BI soon.
deran_naidoo
New Member
I think a Global session variable can handle this. When a variable is set in Power BI Desktop, it can have a DAX expression assigned to it to get a value based on some set of conditions or criteria. When it is published to the service, the variable can be overridden based on an event, like a slicer selection and using SELECTEDVALUE to capture that value and assign it to the variable for example. The overridden variable only lives for that users session but a new user would enter with a default value based on the reports saved state. This variable can then be used as an ALIAS for the column name. Thats probably one way to make column headers dynamic. It also provides a reusable component that can be used again, like in a label to dynamically update text or portions of text. i.e User selects January And Budget a label or column header contains : Setup : "You have selected " & MonthVariableName & " " & LedgerTypeVariableName Output : "You have selected January Budget" Then goes on to select Forecast after that and the label or column header changes Output : "You have selected January Forecast" That would help us provide the correct context for the end-user instead of using generic headers that do not provide the exact context of the data that is being displayed.
rob_solfest1
New Member
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
New Member
Needed urgently, cases are growing to change the static header columns
Bruno_Zambetti
New Member
please use https://ideas.powerbi.com/ideas/idea/?ideaid=15baaa8c-5cb2-4962-90c8-01b2ecfb358a, there are more votes for the idea
powerbi214
New Member

Please, I really need this!

camilo_hurtado_
New Member

Great Idea ¡¡¡, the power of simplicity ¡¡¡