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
• 1,010 points
21 views

1 answer to this question.

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,500 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
31 views
0 votes
0 answers

How do you create a relationship between two queries with same database?

I have some database view with several ...READ MORE

May 28 in Power BI by Phalguni
• 1,010 points
26 views
0 votes
1 answer

How do I show more than one data element in a 'card'?

Hi, In order to show more than one ...READ MORE

answered Jun 13 in Power BI by Avantika
• 1,500 points
18 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
• 37,320 points
46 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,500 points
26 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,500 points
76 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,500 points
46 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
22 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,500 points

edited Mar 9 by Avantika 51 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 May 22 in Power BI by Avantika
• 1,500 points

edited May 23 by Omkar 22 views