How do I create a line chart?

0 votes

I want to re-create a line chart. There should be individual lines for website traffic for 2017,2018,2019 and 2019 target .

image.pngWanted result

After performing all the operations I get the following line chart: 

image.png

Actual result:

image.png

How do I create this chart and what are the steps to be followed?

May 10 in Power BI by Phalguni
• 790 points
14 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi,

From the data mentioned above, you can create measures for 2017, 2018, 2019 target with the help of the following formula:

2019 actual traffic = calculate (sum (Actual Traffic By Channel),

 filter (all('table'),year (date) = 2019 ))
answered May 10 by Avantika
• 1,140 points

Related Questions In Power BI

0 votes
1 answer

How do I know who in my organization has a Power BI account?

You can view the Azure Active Directory ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 14,080 points
23 views
0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 35,800 points
31 views
0 votes
2 answers

How do I get token using javascript API while trying to embed graphs using Power BI

You need to use the generateEmbededToken function. ...READ MORE

answered Oct 3, 2018 in Power BI by Kalgi
• 35,800 points
148 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 35,800 points
38 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10 in Power BI by Avantika
• 1,140 points
18 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2 in Power BI by Avantika
• 1,140 points
27 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 2 in Power BI by Avantika
• 1,140 points
23 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10 in Power BI by anonymous
9 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

answered Mar 8 in Power BI by Avantika
• 1,140 points

edited Mar 9 by Avantika 36 views
0 votes
1 answer

How do I add a filter and a slicer?

Hi, Its OLTP and DW modeling. However, you ...READ MORE

answered 1 day ago in Power BI by Avantika
• 1,140 points

edited 14 hours ago by Omkar 10 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.