Forum Discussion
Database design and modeling
Hi, I want to create a dashboard where I would have a matrix with the categories divided per date and its chart per date and value. For example, I would have a table with the countries, then I wou...
Anonymous , You have to unpivot the tables and bring city and date on rows.
https://radacad.com/pivot-and-unpivot-with-power-bi
Then create common dimensions like city and date join with both tables and use those
Hi Anonymous ,
The second one. Open query editor and selecte the first three columns and use unpivot other columns feature.
Then you will get a table like below and you will be able to create matrix the visual that you wanted.
Best Regards,
Jay
Anonymous , You have to unpivot the tables and bring city and date on rows.
https://radacad.com/pivot-and-unpivot-with-power-bi
Then create common dimensions like city and date join with both tables and use those