cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Slicer and New Table (subset of original table)

Hi, 

 

Created a new table "Yield" based on Original Table "Data". How can use 1 slicer for both table "Yield" and "Data",

 

Currently, to select a "Line", I need to use 2 "Line" slicers, one from each table. 

 

sample data

 

 

2017-05-19 14_56_17-Production Sample Data 0519 - Power BI Desktop.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Slicer and New Table (subset of original table)

Hi @vincentakatoh

 

Glad to hear it worked for you.

 

Yes each dimension you want to link to mutiple fact tables will have to be created separately and linked.

 

 

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

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: Slicer and New Table (subset of original table)

if i am understanding you correctly, you want to filter both tables with the same slicer?  Have you created a relationship between the 2?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper IV
Helper IV

Re: Slicer and New Table (subset of original table)

Hi, Tried to establish relationship between the dates but recieved error message.

 

I'm guessing error message is because Table_Yield is created from Table_data. As such, the "line" columns in both data has the exact same information. 

 

2017-05-19 16_12_51-.png

 

Highlighted
Microsoft
Microsoft

Re: Slicer and New Table (subset of original table)

@vincentakatoh,

 

"You can't create a relationshio between these two columns because one of the columns must have unique values."
This means that it's not supported many to many relationship directly in current Power BI. You could create a brige table. Please refer to the link below to see the details.
https://community.powerbi.com/t5/Desktop/How-to-relate-these-two-Many-to-Many-Tables/td-p/40952

 

Regards,

Charlie Liao

Highlighted
Super User I
Super User I

Re: Slicer and New Table (subset of original table)

Hi @vincentakatoh

 

I presume your source data is the table called "data" in your model.

 

If you want the same dimension ( Line) to slice on both your data and Yield table create a link table called LineTable as

 

LineTable = summarize (data,[Line])

 

Using Manage Relationship connect the LineTable to both Yield and data table.

 

Create Line slicer based on the Linetable[Line].

 

Ttry it out and it should work.

 

If it works for you please accept it 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!
Highlighted
Helper IV
Helper IV

Re: Slicer and New Table (subset of original table)

Hi @CheenuSing,

 

Great! Works perfectly. Last question, if i need to link multiple dimensions (eg date, area, line, station) to both tables.

 

Do I need to create a linktable for each dimension (eg. station, area) ? Below i created 2 individual linktable (date, line). 

 

2017-05-22 13_45_04-Start.png

Highlighted
Super User I
Super User I

Re: Slicer and New Table (subset of original table)

Hi @vincentakatoh

 

Glad to hear it worked for you.

 

Yes each dimension you want to link to mutiple fact tables will have to be created separately and linked.

 

 

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

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors