cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route217 Member
Member

Plot line and bar graph for each year

Hi Experts

 

Is it possible in power bi to plot and bar and line graph for each period as shown in the image below. show i want a line and bar graph for the periods 2016, 2017 , 2018 and 2019.....  i can plot the bars for the individual periods but the line graph total sales plots for the full range 2016 to 2019...

 

when i try and calulcate sale for 2016 and add that to the 2016 bar graph data i get a dot.... the graph on the right is what i am trying to achieve....

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Plot line and bar graph for each year

@Route217 ,

 

You may drag [Year] to Shared axis in Line and clustered column chart.

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.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Plot line and bar graph for each year

@Route217 ,

 

You may drag [Year] to Shared axis in Line and clustered column chart.

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.
Route217 Member
Member

Re: Plot line and bar graph for each year

many thanks for the feedback. that worked.