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
