Power BI Ideas Admin on 24 Jun 2020 20:02:44
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!
- Comments (15)
RE: Dax calculated measure name / Dynamic column headers
Currently, the only way to do it is through a Field Parameter, although this means having to duplicate the field and rename it each time, which is really bad in terms of optimization.
RE: Dax calculated measure name / Dynamic column headers
Qlik Sense has it. I don't understand why PowerBI doesn't. It's critical in order to make understandable the name of the measure and give the PowerBI app a better look&feel. Come on, you've already late!
RE: Dax calculated measure name / Dynamic column headers
I am amazed that this is not basic functionality already.
RE: Dax calculated measure name / Dynamic column headers
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: Dax calculated measure name / Dynamic column headers
For my company it would be of great help and solve many problems that we have after the change to PBI.
RE: Dax calculated measure name / Dynamic column headers
Great Idea ¡¡¡, the power of simplicity ¡¡¡
RE: Dax calculated measure name / Dynamic column headers
Please, I really need this!
RE: Dax calculated measure name / Dynamic column headers
please use https://ideas.powerbi.com/ideas/idea/?ideaid=15baaa8c-5cb2-4962-90c8-01b2ecfb358a, there are more votes for the idea
RE: Dax calculated measure name / Dynamic column headers
Needed urgently, cases are growing to change the static header columns
RE: Dax calculated measure name / Dynamic column headers
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