How can I change column names dynamically

[Jyo27]

Hi Everyone ,

I have the below data .When I select week 12 the below column name current week  should change to week 12 and the previous week should change to week 11. How can I resolve this issue?

Week slicer

11

12

13

Input: 

Current week

Previous week

Week 12

week 11

[Anonymous]

Hi @Big_Guy_j,

Current power bi does not support create dynamic calculated column/table based on filter. They do not work on the same level and you can't use the child level to affect its parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng