cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Jtischler
Helper I
Helper I

Bridge Slicer not slicing 2nd table

Hello all,

 

I have seen many posts that seem to be my use case, but the solutions are not working for me.  

 

Using solution from this post: https://community.powerbi.com/t5/Desktop/Disconnected-Slicer-to-slice-a-table/m-p/2526123

 

The visual is a card, representing a distinct count of a different Facts2 [field2] that should change based on slicer selection filtering Facts2[field1] .

 

I have two facts tables, with many same fields and 1 Bridge table with a common field that I want to use as a slicer.  The only relationship between the facts tables is a 1 to Many, single direction.  And the bridge table to each of the facts table, 1 to many 1 direction.  The slicer is only slicing 1 of the tables not both.

 

I have seen where the solution is to create a measure that is used as a visual filter where the filter is set to 1.  1 represents the value on facts table row when the field value matches selected value.

 

Measure 1 to capture selected value from Facts2 : 

 

SlcCareerTrack = SELECTEDVALUE('Slicer'[Value])
 
Measure 2 in table to return 1 when selected Value from slicer matches field value in table:
 
SelCareerTrack =
var _sel = [SlcCareerTrack]
var _CarTrk = MAX(Facts2[Career Track]
Return
If(CONTAINSSTRING(_CarTrk,_sel),1,0)
 
Issue 1 - "var _sel = [SlcCareerTrack]" - This is supposed to reference the (facts2)[field] but it will only accept measures or functions.  It will not accept (facts table)[field]?? -   RESOLVED - Is looking for the value in Measure 1 NOT Facts table
 
Issue 2 - The visual is a card, representing a distinct count of field that should change based on slicer selection.  When applying the visual filter Measure2 'is 1' - The filter will not allow me to modify the 'is'.  I cannot change the operator nor select the filter options at all.  Its like its frozen. RESOLVED!!! - I changed the card to a table and added the Facts2[Field] which allowed me to configure the filter and then change back to a card!!
 
Issue 3 - When putting this in a table to see the actual data - The Slicer selected value assigns to all rows, which gives them an automatic 1??   RESOLVED.  Value 1 assigns appropriately based on slicer selection with resolution on issue 1
 

Jtischler_0-1680121285698.png

Jtischler_1-1680121366049.png

 

Please help??

 

1 ACCEPTED SOLUTION
Jtischler
Helper I
Helper I

My stubbornness paid off and I was able to solve this on my own, albeit after many hours!

View solution in original post

1 REPLY 1
Jtischler
Helper I
Helper I

My stubbornness paid off and I was able to solve this on my own, albeit after many hours!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors