Slicer and New Table (subset of original table)

[vincentakatoh]

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

[CheenuSing]

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

[vincentakatoh]

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). 

[CheenuSing · Accepted solution]

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

[vanessafvg]

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

[vincentakatoh]

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. 

[v-caliao-msft]

@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