cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markhooten
Regular Visitor

Hierarchy Slicer Stopped Working

Hello!  I have a Hierarchy slicer that has stopped working...it was previously working fine.

FYI - Information security rules won't let me upload a file due to employee information contained within.

 

I have a Visual pulling from a training status table and an organizational table.  The training status visual (there are two on the page, but I'm focused on the top one for now) is not updating when the organizational/hierarchical selection is made.  I have a similar setup on other pages with no issues, so I'm sure it's in my settings somewhere.

 

As seen below, PMDB Initial Training visual is filtered for certain "Items", uses the Status field as the legend and the PMDB PCTG for calculations.

PMDB PCTG formula is:

PDMB PCTG = DIVIDE(Count('PMDB'[Status]),Calculate(count('PMDB'[Status]),ALLSELECTED()))
 

PMDB Training Visual.png

 

Previously, when I would click on the site/location in the organizational hierarchy, the percentages would update with the selected organization's status.  It's no longer working.  I've included the slicer sync info in the screenshot below.

 

PMDB Hierarchy Slicer.png

 

Any hints/tips?

 

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @markhooten 

If only the data is not filtered, please consider whether the interaction of related visualizations has been disabled or the relationship between the related tables has been changed.

 

Best Regards,
Community Support Team _ Eason

View solution in original post

2 REPLIES 2
markhooten
Regular Visitor

Thank you very much - that was it!  The unique User ID between Org and Training Status had broken.

v-easonf-msft
Community Support
Community Support

Hi, @markhooten 

If only the data is not filtered, please consider whether the interaction of related visualizations has been disabled or the relationship between the related tables has been changed.

 

Best Regards,
Community Support Team _ Eason

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.