Simple line chart

[tonyb1986]

HI All, i am new to PowerBI and i am struggling with what i would assume to be a very simple task.

basically i have a sharepoint list which we use to log a 'coat weight' of adhesive, we sample the coat weight from 3 positions.

this data is logged via a powerapp i created and would like to pull the data into the app via powerbi in a line chart, the filters will be the date, one axis would be the 3 positions where the coat weight is sampled and the other axis would be the coat weight value.

i can create this table easily enough in excel as it is a simple line chart but i am really struggling.

attached is a screenshot of what i have created in excel with some dummy data and would like to replicate this.

any help would be greatly appreciated!

[amitchandak · Accepted solution]

@tonyb1986 , If P1 ,P2 and P3 are columns, Unpivot them in power Bi and use

Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11

https://radacad.com/pivot-and-unpivot-with-power-bi

The second option is if they are measures or create measures on them and then create a calculation group. Then you can use them on axis

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[tonyb1986]

Thank you for your response and suggestion, i will give this a go later today and hopefully i succeed, the data in the sharepoint list is exactly how the excel data looks on the image (there is more data collected but this is the relevant data required)