Forum Discussion
Line chart linked to field based table
Sorry Greg_Deckler i haven't understood that you need the raw data.
Please find attached the file that i'm using as database for energy values:
| Month - Year | ITALY Power €/MWh | ITALY GAS €/MWh | France Power €/MWh | France GAS €/MWh |
| gen-19 | 67,65 | 23,67 | 61,16 | 21,92 |
| feb-19 | 57,67 | 20,46 | 46,62 | 18,32 |
| mar-19 | 52,88 | 18,28 | 33,86 | 15,80 |
| apr-19 | 53,35 | 18,60 | 38,08 | 15,11 |
| mag-19 | 50,67 | 17,15 | 37,21 | 13,52 |
| giu-19 | 48,58 | 14,21 | 29,26 | 10,21 |
| lug-19 | 52,31 | 12,51 | 37,66 | 10,87 |
| ago-19 | 49,54 | 11,37 | 33,39 | 10,23 |
| set-19 | 51,18 | 12,56 | 35,54 | 9,64 |
| ott-19 | 52,82 | 12,81 | 38,60 | 10,09 |
| nov-19 | 48,16 | 16,18 | 45,94 | 14,20 |
| dic-19 | 43,34 | 14,66 | 36,46 | 13,12 |
| gen-20 | 47,47 | 13,24 | 38,01 | 11,22 |
| feb-20 | 39,30 | 10,77 | 26,25 | 9,19 |
| mar-20 | 31,99 | 9,98 | 23,83 | 8,48 |
| apr-20 | 24,81 | 8,62 | 13,45 | 6,47 |
| mag-20 | 21,79 | 6,51 | 14,86 | 4,51 |
| giu-20 | 28,01 | 5,89 | 25,79 | 4,95 |
| lug-20 | 38,01 | 6,36 | 33,41 | 4,81 |
| ago-20 | 40,32 | 8,17 | 36,75 | 7,24 |
| set-20 | 48,80 | 11,40 | 47,20 | 10,64 |
| ott-20 | 43,57 | 13,19 | 37,89 | 13,65 |
| nov-20 | 48,75 | 13,84 | 40,11 | 13,56 |
| dic-20 | 54,04 | 16,28 | 48,42 | 16,00 |
| gen-21 | 60,71 | 19,86 | 59,48 | 20,55 |
| feb-21 | 56,57 | 18,09 | 49,01 | 17,43 |
| mar-21 | 60,39 | 18,22 | 50,22 | 17,34 |
| apr-21 | 69,02 | 21,36 | 63,10 | 19,97 |
| mag-21 | 69,91 | 25,27 | 55,28 | 24,64 |
| giu-21 | 84,80 | 28,07 | 73,51 | 28,34 |
| lug-21 | 102,66 | 35,32 | 78,37 | 35,75 |
| ago-21 | 112,40 | 42,27 | 77,30 | 43,70 |
| set-21 | 158,59 | 62,23 | 135,31 | 61,49 |
| ott-21 | 217,63 | 85,39 | 172,45 | 83,87 |
| nov-21 | 225,95 | 80,49 | 217,06 | 79,86 |
| dic-21 | 281,24 | 113,42 | 274,67 | 113,52 |
| gen-22 | 224,50 | 86,02 | 211,42 | 82,18 |
| feb-22 | 211,69 | 81,45 | 185,55 | 78,78 |
| mar-22 | 308,07 | 126,62 | 295,20 | 123,57 |
| apr-22 | 245,97 | 100,17 | 233,10 | 88,61 |
| mag-22 | 230,06 | 89,82 | 197,43 | 75,85 |
| giu-22 | 271,31 | 102,67 | 248,40 | 93,27 |
| lug-22 | 441,65 | 172,88 | 400,87 | 123,63 |
| ago-22 | 543,15 | 233,53 | 492,49 | 157,27 |
| set-22 | 429,92 | 183,41 | 394,70 | 110,65 |
| ott-22 | 211,50 | 78,05 | 178,88 | 48,43 |
| nov-22 | 224,51 | 91,20 | 191,88 | 69,57 |
| dic-22 | 294,91 | 116,60 | 270,89 | 107,81 |
| gen-23 | 174,49 | 68,37 | 132,10 | 58,15 |
| feb-23 | 161,07 | 56,87 | 148,76 | 50,70 |
| mar-23 | 136,38 | 46,58 | 111,96 | 44,29 |
| apr-23 | 134,97 | 44,83 | 106,36 | 41,68 |
| mag-23 | 105,73 | 34,07 | 77,55 | 29,90 |
| giu-23 | 105,34 | 33,14 | 91,29 | 31,08 |
| lug-23 | 112,09 | 31,42 | 77,65 | 29,11 |
| ago-23 | 111,89 | 33,21 | 90,87 | 32,87 |
| set-23 | 115,70 | 37,05 | 88,71 | 35,79 |
| ott-23 | 134,26 | 43,73 | 84,26 | 41,66 |
| nov-23 | 121,74 | 42,53 | 88,96 | 38,01 |
| dic-23 | 114,52 | 36,31 | 68,58 | 33,01 |
| gen-24 | 99,16 | 31,19 | 76,59 | 28,51 |
| feb-24 | 87,63 | 27,84 | 58,37 | 24,97 |
| mar-24 | 88,86 | 28,75 | 53,59 | 26,42 |
I've tried unpivoting all the columns but seems not working as well unfortunately.
Many thanks for your help.
Best Regards
Fabio
Fabio_B This seems to work for me. See PBIX attached below signature. Just unpivot the columns and use the Attribute column as your slicer.
Thanks a lot Greg_Deckler, we're almost there!
Now the chart is showing only one Country/Utility selected, but if i'm selecting more than one it sum the values insted of adding a new line.
Do you think it would be possible to have something like this, adding more than one instead of the sum of the values?Again, thanks for the support.
FabioFabio_B Just put the Attribute column in the legend.