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