Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am having a sample data

CompanyA,2019-01-01,29000
CompanyA,2019-02-01,35000
CompanyA,2019-03-01,43000
CompanyA,2019-04-01,27000
CompanyA,2019-05-01,45000
CompanyA,2019-06-01,21000
CompanyA,2019-07-01,26000
CompanyA,2019-08-01,27285
CompanyA,2019-09-01,26035
CompanyA,2019-10-01,24785

and the expected output will be like

Sample Image

  • Need month names on the X-Axis
  • Barlines should tell me the number of sales
  • multiple lines which show the sales 

How can we able to solve this from the data above? 

1 Answer

0 votes
by (22.5k points)
edited by

You should able to create measures for individual companies and the number of companies is not big than numbers and keep them in "Line values"

Example measures:

CompanyA = calculate(sum(sales), filter(tbl, [company] = "CompanyA"))

and create the same companies for the next 4 companies 

Check the Power bi training provided by Intellipaat 

Also, check out our YouTube video more insights

Related questions

0 votes
1 answer
0 votes
1 answer
asked Feb 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 9, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...