Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 :
Please help??
Solved! Go to Solution.
My stubbornness paid off and I was able to solve this on my own, albeit after many hours!
My stubbornness paid off and I was able to solve this on my own, albeit after many hours!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!