Forum Discussion

jhut's avatar
jhut
Regular Visitor
7 months ago
Solved

Edit Interactions doesn't work

Orgs only have one Cohort and a Cohort has multiple Orgs.   I have 3 visuals a. The Org slicer b. The Cohort slicer c. A table visual listing all the Orgs   I need to set up slicers so that: ...
Need Help
  • jhut's avatar
    jhut
    6 months ago

    I think the issue is that Edit Interactions only works with certain visuals. I got it to work with other visuals but not the ones I wanted

v-echaithra's avatar
v-echaithra
Community Support
6 months ago

Hi jhut ,

There’s a fundamental limitation in Power BI’s visual interactions that explains why this can’t be fully achieved through interactions alone.
Visual interactions can only control whether a slicer filters a visual, or whether it has no impact on a visual. They cannot control which values appear inside another slicer because of this, the requirement is not reliably supported using interactions by themselves.

You can try this workaround, Instead of relying on visual interactions, the correct pattern is to let the data model handle the filtering by introducing a small bridge/dimension table.

Create a Bridge Table
OrgCohort = DISTINCT(
SELECTCOLUMNS(
'FactTable',
"OrgName", 'FactTable'[OrgName],
"CohortName", 'FactTable'[CohortName]
))

Create Relationships

Set the following relationships:

OrgCohort[OrgName] > FactTable[OrgName]

OrgCohort[CohortName] > FactTable[CohortName]

Both should be active and single direction.
Cross-filter direction: OrgCohort > FactTable

Use the Bridge Table in Slicers

Org slicer: OrgCohort[OrgName]

Cohort slicer: OrgCohort[CohortName]

Table visual: Fields from FactTable

Hope this helps.
Thank you.