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
28 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,070 points
38 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
31 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
28 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
36 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
138 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
85 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
26 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 66 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 30 views