Forum Discussion
Org Chart, Filter by selection
Hi, I am trying to build an organization chart. I have 2 columns, Job_Id & Supervisor_Id. The visual does not allow me to filter/drill based on any member in the organization. The reason for...
HI Anonymous,
AFAIK, current power bi does not support creating dynamically calculated columns based on filter or slicers. They are wok on different data levels and you can't use child level to affect its parent.
Notice: the data level of power bi.
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