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, 2019 in Power BI by Phalguni
• 1,020 points
684 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, 2019 by Avantika
• 1,520 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
• 18,540 points
1,112 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, 2019 in Power BI by Phalguni
• 1,020 points
694 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 14, 2019 in Power BI by Avantika
• 1,520 points
703 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, 2019 in Power BI by Avantika
• 1,520 points
659 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, 2019 in Power BI by Avantika
• 1,520 points
2,397 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 3, 2019 in Power BI by Avantika
• 1,520 points
2,604 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, 2019 in Power BI by anonymous
618 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 9, 2019 in Power BI by Avantika
• 1,520 points

edited Mar 9, 2019 by Avantika 5,090 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 23, 2019 in Power BI by Avantika
• 1,520 points

edited May 23, 2019 by Omkar 724 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP