Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

line and column graph

Hi there,


I have data on an excel file that has rows containing the following data points on each column 

A) date, (B) name, (C) value (D)source name.


The source name is either "WEB" or "INTERNAL"


I need to create a line and column graph with dates on the X axis. Value on the Y axis.


How can I show the "INTERNAL" as a Bar and "WEB" as a line? But can't see how to do this




Responsive Resident
Responsive Resident

Hello @Fiona83 ,I assume  your Column Source Name is categorical where it can only be WEB or INTERNAL.
Q. You want to display the different data sources categories separately or on the same visual?
If its on the same visual, I believe filters can work.
1. Use a Line and CLustered chart.
2. Drop the column twice on a Line and CLustered chart
3. Drop the column twice on the filter pane
. For each of the cases, ensure you filter out the other eg. 
For the bar filter out the WEB and for the Line filter out the INTERNAL. 
If this serves as the solution, please leave a like and accept this as the solution...

@Datagulf  thank you for your response. Yes, I want this in one visual.


Sorry not sure what you mean about dropping the columns twice.

Do you mean to create two visuals, and then use transparency to overlap them?

Responsive Resident
Responsive Resident

@Fiona83 , nope .. Same visual. 
what I wanted you to add twice was the column on the same visual.
This is because you are showing 2 different values( WEB and INTERNAL)in different ways, a bar and a line.

Super User
Super User

Hello @Fiona83 ,


use this visual Line and Clustered column Chart as in the screenshot



and you can add the field you want as a column in the column y-axis and the field as line in the ;ine y-axis




If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


Follow me on Linkedin


Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!


Thank you but when I add the source to the Y-axis is then adds this as a "count" not the value 



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors