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
Community Champion
Community Champion

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.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors