Dynimc Multi Line Plots of Large Data Sets

[donalffons]

Hi,

I am quite new to PowerBI and I am struggling with the following problem:

I have a table (Table 1) containing company names and general information. The companies (there are thousands of them) could change over time. It looks like this:

Name	Sector	Info
Apple	Consumer Products	Phones
Google	Software	Search
Pizza Hut	Food	Pizzas
… (thousands of comps)	…	…

I have another table (Table 2) that contains a time-series table about the market capitalization of each company:

Date	Apple	Google	Pizza Hut	… (tousands of comps)
01.01.2001	100	70	10	…
02.01.2001	110	80	20	…
03.01.2001	120	90	30	…
04.01.2001	130	100	40	…
…	…	…	…	…

What I would like to achieve is the following: I would like to plot the market cap from Table 2 in a line plot over time. Then I would like to have a slicer next to the plot, where I can select the companies. Something like in this mockup:

Is this possible in PowerBI? Can I do it with some dynamic measures? Do I need to create custom visuals?

Best regards

-Sebastian

[lalthan · Accepted solution]

Best solution is to unpivot your columns from table 2.  Go to query Editor for Table 2 > Transform.

Click on Date column and select "Unpivot other columns" i.e. it will unpivot all the other columns except Date (which is the selected column).

Rename the Attribute column and then join it with Table1.

[lalthan · Accepted solution]

Best solution is to unpivot your columns from table 2.  Go to query Editor for Table 2 > Transform.

Click on Date column and select "Unpivot other columns" i.e. it will unpivot all the other columns except Date (which is the selected column).

Rename the Attribute column and then join it with Table1.

[donalffons]

OK, that's almost what I want. Thanks!

My table (Table 2) now looks like this (So far, I did not join Table 1 and Table 2):

Date	Companies	Market Cap
01.01.2001	Apple	100
01.01.2001	Google	70
01.01.2001	Pizza Hut	10
02.01.2001	Apple	110
02.01.2001	Google	80
02.01.2001	Pizza Hut	20
…	…	…

When I plot my line plot, I get a good result only when I chose one company in the slicer. As soon as I chose 2 companies, PowerBI seems to show the sum of both companies (see 'Actual Result'):

What would be your recommendation to achieve the 'desired result', i.e. showing separate plots with different colors for all selected companies?

[lalthan · Accepted solution]

On your line chart, add the attribute as a Legend. Then configure your slicer to allow multiple selection. They will come as separate chart

[donalffons]

Thank you! That is exactly what I was looking for.

[Anonymous]

Could you put an image of how the graph looked?

Tanks!