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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
badgerdds
New Member

One slicer for two tables (M:M)

Hi All

 

Hoping someone can help me out - I'm very new to PowerBI so please bare with me! 🙂

 

I have two tables, neither of the two tables have a singluar column that holds unique values, but they do share the same column of data "Business Area". However, what I would like to be able to do, is for both tables to update off once slicer for "Business Area". PowerBI will not let me make a relationship between them using "Business Area" as this is not a unique value.

 

img1.jpg

 

 

you can see above my two tables...

 

 

 

img2.jpg

 

 

my rather crude example 🙂 ... the slicer in the middle is from table 1 "Business Area" - when i change this it will update the graph for table 1 - which is great - but i'd like it to also update table 2 graph to show the Count of "Leavers". both Graphs are just a count of Business Area

 

I hope I'm making sense!?

 

My thanks for your help in advance!

1 ACCEPTED SOLUTION
CheenuSing
Community Champion
Community Champion

Hi @badgerdds

 

Try the following

 

1. Create a Table of Business Areas as the only column.

2. Join this table to bothe Table1 and Table 2 as 1:M relationship - Both

3. Use the table at step 1 for slicer

4. Now check the output of the two graphs.

 

 

If this works for you please accept this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
CheenuSing
Community Champion
Community Champion

Hi @badgerdds

 

Try the following

 

1. Create a Table of Business Areas as the only column.

2. Join this table to bothe Table1 and Table 2 as 1:M relationship - Both

3. Use the table at step 1 for slicer

4. Now check the output of the two graphs.

 

 

If this works for you please accept this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Thank you both very much for your response! - that did the trick 🙂

 

Both solutions worked xx

v-chuncz-msft
Community Support
Community Support

@badgerdds,

 

Drag column from the following calculated table and build relationship on it.

Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( Table1, "Business Area", Table1[Business Area] ),
        VALUES ( Table2[Business Area] )
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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