Forum Discussion
Reproducing an Excel Line chart in Power BI Desktop
Hi all This seems like a simple thing to do but I can't figure this out.... I have a simple table that has Anomaly values against years In Excel I can get a Line chart to plot thes...
So the take away from this is graphs only allow measures to be used on the y axis!
Hi both
Thanks for your input! Had figured the line chart was the correct chart but couldn't get the Anomoly value to be accepted onto the Y Axis (should have mentioned this!). After messing about and reading around, changing the way the data was being bought in, turns out using
SumAnom = SUM( tbl_Anomoly[Anomaly] )
rather the the raw
tbl_Anomoly[Anomaly]value was the way to go and we now have a line chart as required!
Good start to the day! Have liked both solutions but not accepted either as the solution, hope this is ok and thanks for your input!
Have an ace day both!
Cheers
Keith
So the take away from this is graphs only allow measures to be used on the y axis!