Multiple videos play comparison over a period of time.

[Anonymous]

Hello Everyone -

I again need a favour from the group. 

I have a table with a list of videos, individual plays, completion and timestamp. I want to build a report which shows all the hits(count of plays) that the videos are getting over a period of time.

I am looking to do it in the form of a line chart with my videos listed in the Y-axis and time period in x-axis. Tooltip would be the plays. Right now, powerBI shows the aggregated report which doesn't give me exact picture; want to see the videos listed and the number of plays over a period.

Greatly appreciate if anybody could help me out.

Thanks,

[v-shex-msft]

Hi @Anonymous,

It is hard to coding formula from your description, please share some sample data with same data structure and expected result. It will be help for test and build visual graph.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft -

This is the sample format of the table. The first column lists all the videos, the second column list the number of times a video has been played by users and the third is the date played date.

I am looking for a way to sum the number of plays by month for each video and graphically display it this way, so that I can display the highs and lows of a video and in parallel compare it with other videos.

Video	Plays	Date Played
Mov 1	12	11/02/2018
Mov 2	2	2/09/2018
Mov 3	3	2/09/2018
Mov 4	1	1/05/2018
Mov 5	32	17/04/2018
Mov 2	2	28/01/2018
Mov 4	22	1/12/2018
Mov 1	1	1/11/2018
Mov 5	2	2/11/2018
Mov 2	14	10/09/2018

Expected data format:

Hope I am clear now.

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I'd like to suggest you create a line chart with date to axis(switch date to hierarchy mode, keep year, month fields and drill to bottom level), video to legend, play to value fields.

Regards,

Xiaoxin Sheng