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.
Community,
Any help with the below would be much appreciated.
Context - We work with experimental data that has images associated with the experiment that we would like to showcase in Power BI.
1 have 2 tables, Table1 and Table2, shown below.
The 2 tables are connected by CASE ID.
Step 1
I would like to filter table1 by CASE ID, after this I would like to return the PHOTO LINK of the filtered CASE ID and the PHOTO LINK of the CASE ID REF. This step would allow us to show the photos of the CASE ID and the CASE ID REF.
Step 2
I would like to return the filtered CASE ID from above in a calculated column or measure that would have both the filtered CASE ID and CASE ID REF, such that if CASE ID 2 were selected (filtered), the column would populated with CASE ID 1 and 2. This column/measure would be used to filter the photos of the selected CASE ID and CASE ID REF.
Thanks for any possible solutions!!
Solved! Go to Solution.
Hello @Anonymous
My solution would do that because Table3 would be linked to Table1[CASE ID REF] which, in your example would be 1.
Thanks for the response...
Hope that the below may provide some clarity to the question.
Hello @Anonymous
My solution would do that because Table3 would be linked to Table1[CASE ID REF] which, in your example would be 1.
For the photos, you can make a copy of the photo table (Table2) and link the copy to the [CASE ID REF] column in Table1. Making a copy of a table is simple Go to Modeling > New Table and enter the formula
Table3 = Table2
Then you link Table3[CASE ID] to Table1[CASE REF ID]
For a coulm that shows both the [CASE ID] and [CASE REF ID] you can just add a column to Table1 like
=[CASE ID] & ", " & [CASE REF ID]
@Anonymous not very clear hat you are asking in step 2
for step 1, just add a new column in Table1
Photo Link = RELATED( Table2[Photo Link] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |