Plot line and bar graph for each year

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous ,

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

[Anonymous]

many thanks for the feedback. that worked.