Creating tables from a dataset

Hi Anonymous  First unpivot your table. See images below:
Your provided data set:

Open power query, select Month and Session column, Right click and select unpivot other columns. See image below:

Here is the final table output:

Close and load table, select matrix visual and populate data. Here is the desired output:

Format according to your need.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,

Shahariar Hafiz

Hi Anonymous 

In the first step, in order to work with the table effectively, it’s recommended to perform an Unpivot in Power Query.
This will turn it into a vertical table, making it more flexible for analysis.

Then after closing and apply you can create the matrix :

The pbix is attached