Forum Discussion

jaktony's avatar
jaktony
Helper I
1 year ago

Dynamic Column Header on a Matrix

Hi All,

I'm looking for a solution to creating a dynamic measure that will change it's column header based on a slicer selection. I have created 3 slicers (Scenario parameters - Alpha, Beta, Gamma) that pull in current year actuals, PY actuals, budget, forecast, etc... 

The value fields (alpha_all, beta_all, gamma_all) in the matrix lookup the scenario you have selected for your parameters and pull in that scenario data. I want the header of the matrix column to show the selected scenario name based on the slicer and still show the correct $ amount in values.

Current Matrix:

 

Goal Matrix:

ActBudRev Bud
1000500300

 

 

Please follow link for test file and let me know if you have questions. Appreciate all answers and help,thank you!

 

https://drive.google.com/drive/folders/1uOwmy9uOYTu0FA2-6fgIMs_CE3rB90pD?usp=sharing

 

 

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Not possible. All potential column headers must be precomputed in a static disconnected table column.

     

    Consider using Field Parameters instead, or "Personalize Visuals".