Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
TABLE A
name | ID | result | method | |||
A | 123 | 2 | cod | |||
A | 125 | 30 | mod | |||
B | 1246 | 43 | cod | |||
C | 138 | 51 | mod | |||
C | 139 | 23 | eod | |||
D | 527 | 22 | cod | |||
D | 530 | 3 | mod | |||
D | 529 | 40.3 | eod | |||
C | 140 | 2.82 | cod |
|
TABLE B
A ID | B ID | C ID | D ID | |
122 | 1246 | 138 | 527 | |
123 | 1241 | 139 | 530 | |
125 | 1200 | 140 | 529 | |
129 | 1234 | 142 | 520 | |
result:
Hi @Anonymous
Please break the lookup table
Turn off Intraction between slicer
PBIX file - https://drive.google.com/file/d/17bzyqn66L_Tsc6a9ND7nR8fix7dmImuj/view?usp=drive_link
Thanks
Hi @Anonymous
Unpivot the Table B, Copy and paste the code in Advance editor
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Tcu7DcAgDEXRVZBrCv9I8CyI/dfAfklBcy356K1Foko9608dm9mhb7bR7sX2sYCj2PjiAeZ6iTPWcXGAzcEK/tf7AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"A ID" = _t, #"B ID" = _t, #"C ID" = _t, #"D ID" = _t, #" " = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"A ID", Int64.Type}, {"B ID", Int64.Type}, {"C ID", Int64.Type}, {"D ID", Int64.Type}, {" ", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{" "}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {}, "Attribute", "Value")
in
#"Unpivoted Columns"
Create Relation
Create visual
PBIX File link - https://drive.google.com/file/d/17bzyqn66L_Tsc6a9ND7nR8fix7dmImuj/view?usp=sharing
If solve, mark as RESOLVED. Appreaited your Like/Kudis
we need to add A ID ,B ID ,C ID ,D ID as separate slicers.
reference source Re: Releationship - Microsoft Fabric Community