Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
KT-PBI
Frequent Visitor

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 

 

Screenshot 2024-02-27 160817.png

In Excel I can get a Line chart to plot these values

Screenshot 2024-02-27 160843.png

 

But the best I can seem to do in PBI is a scatter chart

 

Screenshot 2024-02-27 160906.png

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

1 ACCEPTED SOLUTION
KT-PBI
Frequent Visitor

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

View solution in original post

4 REPLIES 4
KT-PBI
Frequent Visitor

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!
 
KTPBI_0-1709114909537.png

 

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

KT-PBI
Frequent Visitor

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

Syk
Super User
Super User

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

Syk_0-1709052228703.png

 

audreygerred
Super User
Super User

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:

audreygerred_0-1709052045129.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.