Forum Discussion

GabinAM's avatar
GabinAM
Frequent Visitor
2 years ago
Solved

Flexible Column Name - Field Parameters

Hello everyone ! 😊 Initial Situation I have to work on a tricky dataset with unbrand columns name. Please see below an example.  As you can see, the correct columns name for Value 1 should be...
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    Hello,

    Unfortunately, you are not able to dynamically change the name of a column within a table/matrix visual. What you can do however, is have a dynamic title to your visual. You can then do something like: 

    VizTitle = 

CONCATENATE("Model Based on ", SELECTEDVALUE(Sheet1[Label]))

     

    In projects where I had to create something similar, I called the column "Modeled Value", to indicate that this is a value that is dynamic depending on what the end-user selects

     

ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago

Hello,

Unfortunately, you are not able to dynamically change the name of a column within a table/matrix visual. What you can do however, is have a dynamic title to your visual. You can then do something like: 

VizTitle = 

CONCATENATE("Model Based on ", SELECTEDVALUE(Sheet1[Label]))

 

In projects where I had to create something similar, I called the column "Modeled Value", to indicate that this is a value that is dynamic depending on what the end-user selects

 

  • GabinAM's avatar
    GabinAM
    Frequent Visitor
    2 years ago

    Hi ExcelMonke 

    Thanks for your feedback!