Hierarchy Slicer Stopped Working

[markhooten]

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()))

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.

Any hints/tips?

[markhooten]

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

[v-easonf-msft · Accepted solution]

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