cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brianalva
Helper I
Helper I

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 this is that the SupervisorId at the highest level should be blank or null, for an org chart to display'

 

Is there a way to blank the supervisor column when a selection is performed on the job title slicer.? 

Here is the sample https://drive.google.com/file/d/1P3XFhZT6nK1sLG9MQBaaIAxxGuYttukv/view?usp=sharing

 

 

 

Thanks,

Brian

5 REPLIES 5
v-shex-msft
Community Support
Community Support

HI @brianalva,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
brianalva
Helper I
Helper I

Thanks @AlexisOlson , Link has been updated.

 

AlexisOlson_0-1623853620371.png

It's not publicly accessible.

Re-updated! You are a savior 

AlexisOlson
Super User
Super User

The sample file you linked does not have the columns you describe.

 

AlexisOlson_0-1623790760582.png

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!