Create Line Chart with multiple columns on axis

[Isa-TheHague]

Hello PowerBi Community,

Im working on a project to monitor our Facebook campaign results. Among campaigns that don't use video's there are some campaigns that do use videos.

I work with a export file from Facebook with the following columns and values (example):

Source:

Campaign_Name	Videoviews 25%	Videoviews 50%	Videoviews 75%	Videoviews 100%
A	600	400	100	50
B	400	200	20	10
C	null	null	null	null

As you can see the export file puts the number of users that watched a video to a certain percentage in a column that describes that percentage.

I want to plot the course on videoviews per campaign in a line chart like this:

I do not know if this is the desired way to do it but I came up with the though that the data should be transformed like this:

Transformed table:

Campaign_Name	Percentage viewed	Video views
A	25%	600
A	50%	400
A	75%	100
A	100%	50
B	25%	400
B	50%	200
B	75%	20
B	100%	10

Can you help me create this table within PowerBI / Power Query?

Thanks in advance!

Best Regards,

Isa

[Evgeniy_O · Accepted solution]

Hi @Isa-TheHague 

In Power Query, select columns you want to transform, then select Unpivot button on Transform tab. 

Eugene