Forum Discussion

Jyo27's avatar
Jyo27
Icon for Helper II rankHelper II
3 years ago

How can I change column names dynamically

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 12week 11
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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