Forum Discussion
Visualise differences with selectable reference
hello big power bi community, I am currently struggling with the following problem and hope that someone might have an idea how to solve it: Background: Different materials with different ...
Unpivot your data into a usable format
| ID | Material | Test | Result |
ID_materialapplication quantity_Attribut_Value
| 2 | material 1 | 1,00 % | Test 1 | 13 |
| 2 | material 1 | 1,00 % | Test 2 | 200 |
| 2 | material 1 | 1,00 % | Test 3 | 56-75 |
| 2 | material 1 | 1,00 % | Test 4 | 17 |
| 2 | material 1 | 1,00 % | Test 5 | 56,4 |
| 2 | material 1 | 1,00 % | Test 6 | 86,6 |
| 2 | material 1 | 1,00 % | X-axis | 26,05 |
| 2 | material 1 | 1,00 % | Y-axis | -0,22 |
| 2 | material 1 | 1,00 % | Z-axis | -0,54 |
| 2 | material 1 | 1,00 % | delta X to nearest standard | 0,27 |
| 2 | material 1 | 1,00 % | delta Y to nearest standard | -0,25 |
| 2 | material 1 | 1,00 % | delta Z to nearest standard | 0,01 |
| 2 | material 1 | 1,00 % | Test 13 | 0,1 |
| 2 | material 1 | 1,00 % | Test 16 | 7,1 |
| 2 | material 1 | 1,00 % | Test 17 | cracks |
| 2 | material 1 | 1,00 % | Test 18 | cracks |
| 2 | material 1 | 1,00 % | Test 19 | G0 |
| 2 | material 1 | 1,00 % | Test 20 | 4,6 |
| 4 | material 2 | 1,00 % | Test 1 | 13 |
| 4 | material 2 | 1,00 % | Test 2 | 200 |
| 4 | material 2 | 1,00 % | Test 3 | 70-88 |
| 4 | material 2 | 1,00 % | Test 4 | 15,9 |
| 4 | material 2 | 1,00 % | Test 5 | 54,8 |
| 4 | material 2 | 1,00 % | Test 6 | 86,2 |
| 4 | material 2 | 1,00 % | X-axis | 26,17 |
| 4 | material 2 | 1,00 % | Y-axis | -0,33 |
| 4 | material 2 | 1,00 % | Z-axis | -0,6 |
| 4 | material 2 | 1,00 % | delta X to nearest standard | 0,39 |
| 4 | material 2 | 1,00 % | delta Y to nearest standard | -0,36 |
| 4 | material 2 | 1,00 % | delta Z to nearest standard | -0,05 |
| 4 | material 2 | 1,00 % | Test 13 | 0,13 |
| 4 | material 2 | 1,00 % | Test 16 | 7,3 |
| 4 | material 2 | 1,00 % | Test 17 | small cracks |
| 4 | material 2 | 1,00 % | Test 18 | small cracks |
| 4 | material 2 | 1,00 % | Test 19 | G2 |
| 4 | material 2 | 1,00 % | Test 20 | 7,41 |
| 6 | material 3 | 1,00 % | Test 1 | 13 |
| 6 | material 3 | 1,00 % | Test 2 | 200 |
| 6 | material 3 | 1,00 % | Test 3 | 64-78 |
| 6 | material 3 | 1,00 % | Test 4 | 14,8 |
| 6 | material 3 | 1,00 % | Test 5 | 53 |
| 6 | material 3 | 1,00 % | Test 6 | 84,2 |
| 6 | material 3 | 1,00 % | X-axis | 26,24 |
| 6 | material 3 | 1,00 % | Y-axis | -0,42 |
| 6 | material 3 | 1,00 % | Z-axis | -0,59 |
| 6 | material 3 | 1,00 % | delta X to nearest standard | 0,46 |
| 6 | material 3 | 1,00 % | delta Y to nearest standard | -0,45 |
| 6 | material 3 | 1,00 % | delta Z to nearest standard | -0,04 |
| 6 | material 3 | 1,00 % | Test 13 | 0,08 |
| 6 | material 3 | 1,00 % | Test 16 | 7,6 |
| 6 | material 3 | 1,00 % | Test 17 | cracks |
| 6 | material 3 | 1,00 % | Test 18 | cracks |
| 6 | material 3 | 1,00 % | Test 19 | G0 |
| 6 | material 3 | 1,00 % | Test 20 | 4,59 |
| 9 | material 4 | 1,00 % | Test 1 | 13 |
| 9 | material 4 | 1,00 % | Test 2 | 200 |
| 9 | material 4 | 1,00 % | Test 3 | 68-84 |
| 9 | material 4 | 1,00 % | Test 4 | 14,9 |
| 9 | material 4 | 1,00 % | Test 5 | 53 |
| 9 | material 4 | 1,00 % | Test 6 | 85 |
| 9 | material 4 | 1,00 % | X-axis | 25,98 |
| 9 | material 4 | 1,00 % | Y-axis | -0,3 |
| 9 | material 4 | 1,00 % | Z-axis | -0,45 |
| 9 | material 4 | 1,00 % | delta X to nearest standard | 0,32 |
| 9 | material 4 | 1,00 % | delta Y to nearest standard | -0,32 |
| 9 | material 4 | 1,00 % | delta Z to nearest standard | -0,02 |
| 9 | material 4 | 1,00 % | Test 13 | 0 |
| 9 | material 4 | 1,00 % | Test 16 | 7,3 |
| 9 | material 4 | 1,00 % | Test 17 | cracks |
| 9 | material 4 | 1,00 % | Test 18 | cracks |
| 9 | material 4 | 1,00 % | Test 19 | G1 |
| 9 | material 4 | 1,00 % | Test 20 | 3,22 |
| 11 | material 5 | 1,00 % | Test 1 | 13 |
| 11 | material 5 | 1,00 % | Test 2 | 200 |
| 11 | material 5 | 1,00 % | Test 3 | 67-76 |
| 11 | material 5 | 1,00 % | Test 4 | 13,7 |
| 11 | material 5 | 1,00 % | Test 5 | 50,6 |
| 11 | material 5 | 1,00 % | Test 6 | 84,6 |
| 11 | material 5 | 1,00 % | X-axis | 26,65 |
| 11 | material 5 | 1,00 % | Y-axis | -0,97 |
| 11 | material 5 | 1,00 % | Z-axis | -0,35 |
| 11 | material 5 | 1,00 % | delta X to nearest standard | 0,99 |
| 11 | material 5 | 1,00 % | delta Y to nearest standard | -0,99 |
| 11 | material 5 | 1,00 % | delta Z to nearest standard | 0,08 |
| 11 | material 5 | 1,00 % | Test 13 | 0,09 |
| 11 | material 5 | 1,00 % | Test 16 | 7,7 |
| 11 | material 5 | 1,00 % | Test 17 | cracks |
| 11 | material 5 | 1,00 % | Test 18 | cracks |
| 11 | material 5 | 1,00 % | Test 19 | G0 |
| 11 | material 5 | 1,00 % | Test 20 | 4,47 |
| 3 | material 1 | 3,00 % | Test 1 | 13 |
| 3 | material 1 | 3,00 % | Test 2 | 200 |
| 3 | material 1 | 3,00 % | Test 3 | 79-88 |
| 3 | material 1 | 3,00 % | Test 4 | 10,4 |
| 3 | material 1 | 3,00 % | Test 5 | 45,7 |
| 3 | material 1 | 3,00 % | Test 6 | 83 |
| 3 | material 1 | 3,00 % | X-axis | 26,24 |
| 3 | material 1 | 3,00 % | Y-axis | -0,45 |
| 3 | material 1 | 3,00 % | Z-axis | -0,57 |
| 3 | material 1 | 3,00 % | delta X to nearest standard | 0,46 |
| 3 | material 1 | 3,00 % | delta Y to nearest standard | -0,48 |
| 3 | material 1 | 3,00 % | delta Z to nearest standard | -0,02 |
| 3 | material 1 | 3,00 % | Test 13 | 0,03 |
| 3 | material 1 | 3,00 % | Test 16 | 7,7 |
| 3 | material 1 | 3,00 % | Test 17 | small cracks |
| 3 | material 1 | 3,00 % | Test 18 | small cracks |
| 3 | material 1 | 3,00 % | Test 19 | G1 |
| 3 | material 1 | 3,00 % | Test 20 | 5,43 |
| 5 | material 2 | 3,00 % | Test 1 | 13 |
| 5 | material 2 | 3,00 % | Test 2 | 200 |
| 5 | material 2 | 3,00 % | Test 3 | 67-80 |
| 5 | material 2 | 3,00 % | Test 4 | 9,3 |
| 5 | material 2 | 3,00 % | Test 5 | 42,5 |
| 5 | material 2 | 3,00 % | Test 6 | 82,4 |
| 5 | material 2 | 3,00 % | X-axis | 26,36 |
| 5 | material 2 | 3,00 % | Y-axis | -0,55 |
| 5 | material 2 | 3,00 % | Z-axis | -0,57 |
| 5 | material 2 | 3,00 % | delta X to nearest standard | 0,58 |
| 5 | material 2 | 3,00 % | delta Y to nearest standard | -0,58 |
| 5 | material 2 | 3,00 % | delta Z to nearest standard | -0,02 |
| 5 | material 2 | 3,00 % | Test 13 | 0,04 |
| 5 | material 2 | 3,00 % | Test 16 | 7,4 |
| 5 | material 2 | 3,00 % | Test 17 | cracks |
| 5 | material 2 | 3,00 % | Test 18 | cracks |
| 5 | material 2 | 3,00 % | Test 19 | G0 |
| 5 | material 2 | 3,00 % | Test 20 | 4,44 |
| 7 | material 3 | 3,00 % | Test 1 | 13 |
| 7 | material 3 | 3,00 % | Test 2 | 200 |
| 7 | material 3 | 3,00 % | Test 3 | 78-85 |
| 7 | material 3 | 3,00 % | Test 4 | 9,5 |
| 7 | material 3 | 3,00 % | Test 5 | 43,2 |
| 7 | material 3 | 3,00 % | Test 6 | 81,3 |
| 7 | material 3 | 3,00 % | X-axis | 26,44 |
| 7 | material 3 | 3,00 % | Y-axis | -0,63 |
| 7 | material 3 | 3,00 % | Z-axis | -0,58 |
| 7 | material 3 | 3,00 % | delta X to nearest standard | 0,66 |
| 7 | material 3 | 3,00 % | delta Y to nearest standard | -0,66 |
| 7 | material 3 | 3,00 % | delta Z to nearest standard | -0,03 |
| 7 | material 3 | 3,00 % | Test 13 | 0,07 |
| 7 | material 3 | 3,00 % | Test 16 | 7,3 |
| 7 | material 3 | 3,00 % | Test 17 | cracks |
| 7 | material 3 | 3,00 % | Test 18 | cracks |
| 7 | material 3 | 3,00 % | Test 19 | G0 |
| 7 | material 3 | 3,00 % | Test 20 | 5,16 |
| 10 | material 4 | 3,00 % | Test 1 | 13 |
| 10 | material 4 | 3,00 % | Test 2 | 200 |
| 10 | material 4 | 3,00 % | Test 3 | 56-76 |
| 10 | material 4 | 3,00 % | Test 4 | 9,9 |
| 10 | material 4 | 3,00 % | Test 5 | 43,7 |
| 10 | material 4 | 3,00 % | Test 6 | 82,2 |
| 10 | material 4 | 3,00 % | X-axis | 26,17 |
| 10 | material 4 | 3,00 % | Y-axis | -0,49 |
| 10 | material 4 | 3,00 % | Z-axis | -0,45 |
| 10 | material 4 | 3,00 % | delta X to nearest standard | 0,51 |
| 10 | material 4 | 3,00 % | delta Y to nearest standard | -0,51 |
| 10 | material 4 | 3,00 % | delta Z to nearest standard | -0,02 |
| 10 | material 4 | 3,00 % | Test 13 | -0,05 |
| 10 | material 4 | 3,00 % | Test 16 | 7,9 |
| 10 | material 4 | 3,00 % | Test 17 | cracks |
| 10 | material 4 | 3,00 % | Test 18 | cracks |
| 10 | material 4 | 3,00 % | Test 19 | G0 |
| 10 | material 4 | 3,00 % | Test 20 | 2,87 |
| 12 | material 5 | 3,00 % | Test 1 | 13 |
| 12 | material 5 | 3,00 % | Test 2 | 200 |
| 12 | material 5 | 3,00 % | Test 3 | 67-90 |
| 12 | material 5 | 3,00 % | Test 4 | 9,7 |
| 12 | material 5 | 3,00 % | Test 5 | 43,1 |
| 12 | material 5 | 3,00 % | Test 6 | 81,6 |
| 12 | material 5 | 3,00 % | X-axis | 28,22 |
| 12 | material 5 | 3,00 % | Y-axis | -2,51 |
| 12 | material 5 | 3,00 % | Z-axis | -0,29 |
| 12 | material 5 | 3,00 % | delta X to nearest standard | 2,56 |
| 12 | material 5 | 3,00 % | delta Y to nearest standard | -2,53 |
| 12 | material 5 | 3,00 % | delta Z to nearest standard | 0,14 |
| 12 | material 5 | 3,00 % | Test 13 | 0,4 |
| 12 | material 5 | 3,00 % | Test 16 | 7,3 |
| 12 | material 5 | 3,00 % | Test 17 | cracks |
| 12 | material 5 | 3,00 % | Test 18 | cracks |
| 12 | material 5 | 3,00 % | Test 19 | G1 |
| 12 | material 5 | 3,00 % | Test 20 | 3,36 |
| 1 | Standard 1 | 0,00 % | Test 1 | 13 |
| 1 | Standard 1 | 0,00 % | Test 2 | 200 |
| 1 | Standard 1 | 0,00 % | Test 3 | 63-79 |
| 1 | Standard 1 | 0,00 % | Test 4 | 17,5 |
| 1 | Standard 1 | 0,00 % | Test 5 | 57,5 |
| 1 | Standard 1 | 0,00 % | Test 6 | 86,4 |
| 1 | Standard 1 | 0,00 % | X-axis | 25,78 |
| 1 | Standard 1 | 0,00 % | Y-axis | 0,03 |
| 1 | Standard 1 | 0,00 % | Z-axis | -0,55 |
| 1 | Standard 1 | 0,00 % | Test 16 | 7 |
| 1 | Standard 1 | 0,00 % | Test 17 | cracks |
| 1 | Standard 1 | 0,00 % | Test 18 | cracks |
| 1 | Standard 1 | 0,00 % | Test 19 | G1 |
| 1 | Standard 1 | 0,00 % | Test 20 | 4,84 |
| 8 | Standard 2 | 0,00 % | Test 1 | 13 |
| 8 | Standard 2 | 0,00 % | Test 2 | 200 |
| 8 | Standard 2 | 0,00 % | Test 3 | 65-85 |
| 8 | Standard 2 | 0,00 % | Test 4 | 17,5 |
| 8 | Standard 2 | 0,00 % | Test 5 | 56,9 |
| 8 | Standard 2 | 0,00 % | Test 6 | 86,2 |
| 8 | Standard 2 | 0,00 % | X-axis | 25,66 |
| 8 | Standard 2 | 0,00 % | Y-axis | 0,02 |
| 8 | Standard 2 | 0,00 % | Z-axis | -0,43 |
| 8 | Standard 2 | 0,00 % | delta X to nearest standard | N/A |
| 8 | Standard 2 | 0,00 % | Test 16 | 7,6 |
| 8 | Standard 2 | 0,00 % | Test 17 | cracks |
| 8 | Standard 2 | 0,00 % | Test 18 | cracks |
| 8 | Standard 2 | 0,00 % | Test 19 | G0 |
| 8 | Standard 2 | 0,00 % | Test 20 | 5,55 |