Hi, community!
I am new here and in power bi.
I'm trying to make my first matrix with data from different tables. I have 4 tables (VIEWINGS, VIEWINGSGROUPS, ATTENDEES) with the following columns:
MONTH
MEASURE
DIFF
Where Month is the number of the month, Measure is the measure of that table for said month and DIFF is the difference with the previous month.
I also have a table MONTH_NAME that matches the number of the month with the name of the month. I also have all the relationships between these tables.
The idea is to show a matrix that is as follows
Columns : Months (January, February.....)
Rows : The names of the tables (VIEWINGS, VIEWINGSGROUPS, ATTENDEES)
Cell values: The values of the MEASURE field depending on the row and the column, also I would like to show the difference as well (but this is optional)
I've been trying to come up with a result for quite some time and I can't. Can you guide me about which visualization I can use and how to configure it?
Do you think it is necessary to create a new pivot table?
Thanks for your help!
