Reproducing an Excel Line chart in Power BI Desktop

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

So the take away from this is graphs only allow measures to be used on the y axis!

[Syk]

Hey Keith! Have you used the line chart in Power BI? It should format for you even if your years are aggregated

[audreygerred]

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: