Forum Discussion

allanthanh's avatar
allanthanh
Regular Visitor
9 years ago

Line and clustered column chart - Comparing MoM

I am very new to Power BI. I am trying to compare my cost and click data month over month for 2015 and 2016. However, when ever I add my 2016 numbers, it just adds it all together for both costs and clicks and puts it on the chart. I have some picture below illustrating my problem. 

 

 

 

 

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi allanthanh,

     

    In your scenario, what's the desired results do you want? If you only want to display Cost 2016 and Clicks 2016 in the chart, please remove Cost 2015 and Clicks 2015 field from the chart. If possible please share the .pbix file for our analysis.

     

    Reference:

    Combo Chart in Power (Tutorial)

     

    Best Regards,
    Qiuyun Yu 

    • allanthanh's avatar
      allanthanh
      Regular Visitor
      9 years ago

      v-qiuyu-msft, Thanks for the reply. I am essentially trying to recreate this chart in Power BI instead of Excel. Is it not possible?

       

       

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        MattAllington

        The Issue I have with the Line and Clustered Column Chart is the following:

        and I don't know if there's really a solution other than creating individual Measures for the LIne Values

         

        The Column Series automatically slice the data into years however I wish they would do the the same for the Line Values!

        (I do realize it says Column Series so it slices the Data only for the Column Values)

        However I wish this actually acted more I guess like a Legend (slicing both Measures for the Columns and the Lines)

        Hopefully this example will illustrate...

        So here's my setup

        Shared Axis - Month

        Column Series - Year

        Column Values - Volume

        Line Values - Avg Price (represented by Green Line in picture)

        PLUS a Year Slicer!

         

         

        So by default you'll automatically get a column for each Year with only one Measure in the Column Series.

        However if you do not write explicit Measures for the years selected

        you'll get 1 line averaging each Month's price over all years selected - the one in green.

        To get the individual lines you have to write separate Measures!

         

        Hope this makes sense...

        I hope they add a feature like this someday in the not too distant future :smileyhappy:

         

        Thanks! :smileyhappy:

         

        Any suggestions are welcomed:smileyhappy:

        Anonymousor Anonymous or Vvelarde

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago
    allanthanh wrote:

    I am very new to Power BI. 

     

     

     

    There is a lot to learn. Your table shape needs some work first. 

    You wouldn't load the 2015 and 2016 tables at all. You can bring them into "get data" without loading them, and append them there. You also should not have clicks and cost columns per year, you need a clicks colum, a cost colum nad a year column. 

     

    Apart from that, you will find some good foundation reading at my website here 

    http://exceleratorbi.com.au/knowledge-base/#

     

    I suggest you read everything in the key concepts menu