Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
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).
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
if i am understanding you correctly, you want to filter both tables with the same slicer? Have you created a relationship between the 2?
Proud to be a Super User!
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.
"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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |