Line and clustered column chart - Comparing MoM

[allanthanh]

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. 

[MattAllington]

---

@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

[v-qiuyu-msft]

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]

@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]

@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

Thanks!

Any suggestions are welcomed

@Anonymousor @KHorseman or @Vvelarde

[allanthanh]

@Sean Wow this actually helped a ton. So I got it to compare my costs by month side by side. But my clicks (line value) is just showing the average. Is there a line series function like the column one has for these types of chart? Because I want it to show my 2015 clicks & 2016 clicks as lines.