Forum Discussion
Simple line chart
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 , 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)