dynamic column name in a table

[jja]

Hi

is there a way to set a dynamic column name of a table based on slice selection?

lets say i have columns with names Sales this year(it is a measure), Sales last year(also a measure)

I have a slicer and what i want is to select 2020 then insted of Sales this year i want to show "Sales 2020" and instead of Sales last year i want to show "Sales 2019"

[v-diye-msft]

Hi @jja 

Sure, it's possible.

Check my dummy pbix attached.

[jja]

Hi @v-diye-msft 

It is not about the dynamic data in a column - it is about dynamic column name

[v-diye-msft · Accepted solution]

Hi @jja 

Kindly check below attached.

Please note that we can't change the column name based on the slicer, I'd suggest you use the Matrix to be a workaround.

[v-diye-msft]

Hi @jja 

Do you mean to keep the data unchanged by just change the column name dynamically??

[jja]

Hi @v-diye-msft 

no data in column will change according slicer selection and according selection also column name has to change

if i select year 2019 then column name is 2019 and data in column is 2019

[v-diye-msft]

working on it.

[amitchandak]

Refer, if these can help

https://community.powerbi.com/t5/Desktop/Dynamic-column-name-from-its-value/td-p/189442

https://community.powerbi.com/t5/Desktop/Dynamic-Column-Name-based-on-Slicer-Selection/td-p/549497

https://community.powerbi.com/t5/Desktop/Dynamic-Variable-Column-Header-Names-Changing-with-Slicer/t...