Forum Discussion
Modelling Demographics Across Channels
Hi Everyone,
I'm very new to Power BI and am a very basic user tasked with creating a dashboard that compares percentages of men and women appearing on different news platforms displayed over time.
The data is very simple. Every TV Platform has it's own table, as below.
"Channel 1"
| Month | Channel | Male % | Female % |
| Jul-19 | Channel 1 | 47% | 53% |
| Aug-19 | Channel 1 |
"Channel 2"
| Month | Channel | Male % | Female % |
| Jul-19 | Channel 2 | 51% | 49% |
| Aug-19 | Channel 2 |
The relationship is shown in a third table "Categories"
| Department | Channel |
| News | Channel 1 |
| News | Channel 2 |
I hope to create a dashboard where I can see the departmental average, and then drill down to see each channel's total.
I need to keep the month field so that I can also show the trend over time.
Creating these individually isn't a problem but when I try to add them together the table shows the Gender % fields as separate.
In Fields I am selecting
"Categories"
Y - Channel
"Channel 1"
Female %
Male %
"Channel 2"
Female %
Male %
The resulting table looks like this;
| Channel | Male % | Female % | Male % | Female % |
| Channel 1 | 47% | 53% | ||
| Channel 2 | 51% | 49% |
I would love to be able to report on the average and drill down to each channel. Any help or guidance any of you can give me would be so appreciated. I'm open to rearranging the data in any way I can to ensure ongoing clarity.
Many thanks!
Anonymous why dont you append teh channel tables together? you can append them in power query see attached
3 Replies
Anonymous why dont you append teh channel tables together? you can append them in power query see attached
Anonymous
Hi,
Although you have explained the requirement in details, still I have questions around it.
I have created a sample data model based on the description, which you may find it here
I have questions around the third table as what are the views/reports you would like to create with it?
I would recommend to add more sample data in the file I have shared and use it to explain the requirement.
Rgds,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
