Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |