Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mikeydk
New Member

Basic questions from a beginner

‎03-13-2017 11:52 PM

Hey

 

How do I create a line chart from CSV? 

 

(I do only get SUM/COUNT on sale numbers)

 

CSV:

 

Date, Sale

01-01-2017,12

01-02-2017,13

01-03-2017,14

01-04-2017,12

01-05-2017,11

 

Thanks in advance

Labels:
Message 1 of 2
404 Views
0
1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

‎03-14-2017 12:18 AM

Hi @mikeydk,

 

In your sample dataset, you only have 1 row per day.  In a real dataset, you may have thousands or millions of rows for the 1st Jan, so you can see why the SUM/COUNT might be useful.

 

Are you getting a basic line chart now with those numbers?

 

 

 

linechart.png

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Message 2 of 2
490 Views
0
1 REPLY 1
Phil_Seamark
Employee
Employee

‎03-14-2017 12:18 AM

Hi @mikeydk,

 

In your sample dataset, you only have 1 row per day.  In a real dataset, you may have thousands or millions of rows for the 1st Jan, so you can see why the SUM/COUNT might be useful.

 

Are you getting a basic line chart now with those numbers?

 

 

 

linechart.png

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Message 2 of 2
491 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All