Forum Discussion
Date Slicer selected value
Hi hassanh2,
Did this field you meanitons is a calculated column? If that is the case, I think you can't use calculated column to achieve this requirement.
AFAIK, current power bi does not support to create dynamic column/table based on filter effect. They do not work on the same level and the child not able to affect the parent level.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
Hi hassanh2,
Did this field you meanitons is a calculated column? If that is the case, I think you can't use calculated column to achieve this requirement.
AFAIK, current power bi does not support to create dynamic column/table based on filter effect. They do not work on the same level and the child not able to affect the parent level.
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
Hello Anonymous, you are absolutely right, It is a calculated column. Thanks for expalaining the issue in details.
So is there any work around to achieve this (Updating a calculated column based on a filter) ?
Regards,Hesham
HI hassanh2,
You can create a query parameter and turn on the 'enable load' option on query editor side to load it as a table.
Then you can extract the generated table field values as parameter to create calculated column.
After these steps, the calculated column result will be changes if you modify the query parameter values and refresh on the data source.
Regards,
Xiaoxin Sheng
