Forum Discussion
Creating table from a selected slicer value
Hi Gutts_Zero,
What type of table you mean? If you mean the calculated table, current power bi does not support to create dynamic calculated column/table based on filter effect, they do not work on the same data level, and you can't use child level to effect its parent level.
If you mean table visual, you should create a unconnected table or what if parameter table as source of slicer.
Then you can write a measure formula as filter to use on table visual to apply custom filter effect based on your selection.
Applying a measure filter in Power BI - SQLBI
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