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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DebbieE
Community Champion
Community Champion

Creating 2 slicers and making sure a 1 slicer selection affects the other slicer selection

I have the following star schema in power BI

 

Star Schema.png

The report requires a slicer from Dim B. Then a slicer on DimA

Unfortunately the report is a table and there is nothing from the fact table in the table.

When I slice on B I can still see everything in A

I really dont want to set up any multiple directions on the relationships. Is there anything I can do to get this working?

2 REPLIES 2
olgad
Super User
Super User

@DebbieE Have my answer solved your problem? If so, can you please accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

Hi Debbie, I have some twisted logic for you if you would like to go creative:)

Duplicate /Reference your Fact table, remove all the columns except AKey and BKey.
Remove the duplicates. Append the query from Atable, Append the query from B Table, this way you ensure that you get all of the As and all of the Bs irrespective whether they are in your Fact Table.
Then create a primary key in your fact table and in your new table Akey-Bkey.
Remove all the unnecessary columns except Akey Bkey and PrimaryKey. 
Disable Load on A, B. Create Relationships Fact TAble and New Table. 
Then use Akey from this table and Bkey for your slicers. there will be blanks in both, filter them out on the visual level. and voila:)

olgad_0-1678815001081.png

Let me know if that works for you.


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors