Forum Discussion
Simple line chart
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!
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
2 Replies
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
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)
