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 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
Solved! Go to Solution.
In Power Query, select columns you want to transform, then select Unpivot button on Transform tab.
Eugene
In Power Query, select columns you want to transform, then select Unpivot button on Transform tab.
Eugene
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |