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
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.
RE: Dax calculated measure name / Dynamic column headers
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.
RE: Dax calculated measure name / Dynamic column headers
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.
RE: Dax calculated measure name / Dynamic column headers
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.
RE: Dax calculated measure name / Dynamic column headers
Perhaps this could be achieved by assigning an ALIAS to the measure field