Vertical bar and line chart

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:

 

Product201620172018Avg
Wipes56856869
Soap 27 27
Sampoo1414 14
Oil525511574
Powder42655353

 

Expected Chart:

Column chart with Avg Line.GIF

 

Best Regards

Bikash

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    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:

    image.png

    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.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    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:

    image.png

    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.

This discussion has been closed.