Dynamic column names from measure

[zervino]

I would like to create a table where the column names are the years.

Currently I have two drop down slicers to select the years to compare (ie. Year 1, Year 2). I can correctly create the table below, but the column headers show Year 1 and Year 2. Instead I would like to show the selected year numbers (which are stored in other measures: year_1, year_2)

Is this possible?

[ChiragGarg2512]

@zervino , Look into field parameters if that could help in this situation.

Material on field parameter:

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Thank You