Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Oggie
Frequent Visitor

Automatic selection of filter value based on another dimension

I have created a graph that shows a benchmark that compares the KPI for a selected legal entity with other legal entities:

Oggie_0-1718789980344.png

I am using the following code to change the color for the selected division

Highlight selected TS = 
if(
    ISFILTERED('Department copy') &&
    VALUES('dim_department'[legal_entity_name]) IN VALUES('Department copy'[legal_entity_name]),
    "Green", "Light Gray")

 The "Department copy"-table is a copy of "dim_department" which is setup only for this purpose, but there is no relationship between the tables since I don't want selections of "dim_department" to filter "Department Copy".

So far so good.... but I want a slicer of "dim_department" to automatically select the same legal entity in the slicer that gives the highlighted value (or any other solution apart from slicer).

I tried to do the following solution:

1. Create a measure to display selected value (works fine)

SelectedLegalEntity = SELECTEDVALUE('dim_department'[legal_entity_name])

 
2. Create a new column in "Department Copy" to decide which value that is selected. (Doesn't work... can't get any values from "SelectedLegalEntity". All rows in table shows "0".)

IsSelected = IF('department copy'[legal_entity_name] = [SelectedLegalEntity], 1, 0)

 
Next step was to add "IsSelected" to the visual filter with the condition "1".

Is this a viable solution? Where do I go wrong? Any other solution possible?


Best regards
Stefan

1 ACCEPTED SOLUTION
Oggie
Frequent Visitor

Found the solution online after some search...


Sync two different slicers from different tables without a relationship in Power BI (youtube.com)

The solution is to sync the slicers by the Advanced Options and give them a common group name.

Oggie_0-1718797418798.png

 

View solution in original post

1 REPLY 1
Oggie
Frequent Visitor

Found the solution online after some search...


Sync two different slicers from different tables without a relationship in Power BI (youtube.com)

The solution is to sync the slicers by the Advanced Options and give them a common group name.

Oggie_0-1718797418798.png

 

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors