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 I
Super User I

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors