Dynamic Column Header on a Matrix

[jaktony]

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:

Act	Bud	Rev Bud
1000	500	300

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

[lbendlin]

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

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