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 these values
But the best I can seem to do in PBI is a scatter chart
I can never get the column charts (clustered or stacked) to plot a simple x vs y plot.
Feel like I'm missing a trick here. Have formatted the years as whole numbers and the only thing I can think of is that it's direct number plotting rather than aggregation / summing etc for the Anomaly values. Can't really get the scatter chart to behave as I'd like it either.
All thoughts welcomed!
Cheers
Keith
4 Replies
Hi! If you create a line chart with the x-axis set to categorical instead of continuous, and ensure that it is sorted ascending by year you can get the look you are going for:
Hey Keith! Have you used the line chart in Power BI? It should format for you even if your years are aggregated
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 rawtbl_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
