Visualising results and limits in one visual

[Anonymous]

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

[v-yingjl · Accepted 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.

[Anonymous]

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