cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chydewf1 Regular Visitor
Regular Visitor

Seperating years on a plot

Hi 

 

I have been using Power BI for a month or so now, but one thing I cannot get my head around is how to plit up a time based graph to show a different line for each year and overlay them.

 

I have an old historic data set which cover 2015, 2016 and 2017 in a single data table and my new data which is pulled in from sharepoint.  

 

But the old data Only plots as one line, whereas I would like a line for each year.

Capture.JPG

 

I would love it to look more like this

 

Capture2.JPG

 

Pleae help - i'm getting desperate!

 

Thanks

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Seperating years on a plot

@chydewf1,

 

You may use Table.Combine or UNION Function to create a new table, then drag [Year] to Legend.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Seperating years on a plot

@chydewf1,

 

You may use Table.Combine or UNION Function to create a new table, then drag [Year] to Legend.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 337 members 3,930 guests
Please welcome our newest community members: