Vertical bar and line chart

user01073

Hi,

I am trying to build a card where my yearly data will be shown in vertical bars and yearly avg to be shown in a line like attached.

Please advice.

 

Available Sample Data:

 

Product	2016	2017	2018	Avg
Wipes	56	85	68	69
Soap		27		27
Sampoo	14	14		14
Oil	52	55	115	74
Powder	42	65	53	53

 

Expected Chart:

 

Best Regards

Bikash

BlueRooster

Using the table you provided, you'll first want to select the Line + Grouped Bar chart type.

 

Then drag the columns into the chart like so:

The first measure (green value) will be your line, while the other columns are separate bars.

 

Hope this helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

BlueRooster

Using the table you provided, you'll first want to select the Line + Grouped Bar chart type.

 

Then drag the columns into the chart like so:

The first measure (green value) will be your line, while the other columns are separate bars.

 

Hope this helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.