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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Fiona83
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

 

Thanks

 

5 REPLIES 5
Datagulf
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?

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

Idrissshatila
Super User
Super User

Hello @Fiona83 ,

 

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

Idrissshatila_0-1673431237747.png

 

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

 

Idrissshatila_1-1673431298312.png

 

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!




@Idrissshatila 

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

Fiona83_0-1673437507574.png

 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.