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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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?

1 REPLY 1
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.