Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear,
I receive Certificats of Analysis that are preprocessed by Sharepoint Syntex ((since it is a huge number...).
On these certificates, I can see the respective results for each delivery like in the given table.
I was able to have a good visualisation of these results. However, I wouls also like to see the specified limits of the corresponding grits (coloumn "Körnung").
These limits are specified by grit ("Körnung") and type of grain ("Kornart"). And build up like this:
From my first assumption, I would need (at least one) further table, but can anyone point me in the right direction on how to proceed afterwards?
Thank you for your support,
regards
Philip
Solved! Go to Solution.
Hi @Anonymous ,
You can unpivot your types columns in power query, close and apply into power bi dekstop.
Create two measures like this:
Lower = MIN('Unpivot table'[Value])
Upper = MAX('Unpivot table'[Value])
The table would be like this in a Matrix visual:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can unpivot your types columns in power query, close and apply into power bi dekstop.
Create two measures like this:
Lower = MIN('Unpivot table'[Value])
Upper = MAX('Unpivot table'[Value])
The table would be like this in a Matrix visual:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl ,
thank you for your support. After trying your approach, I ran into issues, since a unpivoting of any coloumn lead to errors in the corresponding tables.
So I solved this by using a LOOKUPVALUE DAX.
However I believe that your answer would have solved my challenge - if I had been able to track the error down.
Thank you,
best regards
Philip
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |