Forum Discussion
Helper IIHow to show dynamic values based on user selection in column
How to show dynamic values based on user selection in column.
have a slicer i.e on Month shows values like Jan 23 , feb 23 ..... so on
i created a calculated column to show the current month i.e Jan 24.
now user selects the slicer value Nov 23 , that is the current month to show Nov 23 values in the column and also column header changes to nov 23 this is purely based on user selection.
please help me on this very critical for me
current month dax logic used =
HI sunil222,
Current power bi does not support to create dynamic column/table based on filter effect. They are not host on the same level and you can't use the child level to affect its parent. I'd like to suggest creating measure expression to instead.
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
1 Reply
HI sunil222,
Current power bi does not support to create dynamic column/table based on filter effect. They are not host on the same level and you can't use the child level to affect its parent. I'd like to suggest creating measure expression to instead.
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