Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
allanthanh
Regular Visitor

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. 

 

 

chart.JPG

 

2016 numbers.JPG

 

relationships.JPG

5 REPLIES 5
MattAllington
Community Champion
Community Champion


@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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
v-qiuyu-msft
Community Support
Community Support

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

sasdf.JPG

 

Sean
Community Champion
Community Champion

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

 

Line and Clustered Column ISSUE.png

 

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 Smiley Happy

 

Thanks! Smiley Happy

 

Any suggestions are welcomedSmiley Happy

@Anonymousor @KHorseman or @Vvelarde

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.