Categorize data by week number using by date

[Anonymous]

Hi, our client currently has an Excel sheet wherein they count customers using a specific category by date (see screenshot below). 

I'm new to Power BI so I'm wondering if it's possible to recreate this layout. Thank you.

[amitchandak]

@Anonymous , Select the first column and use unpivot other columns in Power query -> Transform Tab

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s

[Anonymous]

Hi @amitchandak , I believe it's not a pivot column, they just manually added the numbers and just want me to replicate it in Power BI. The source looks like this.

[Anonymous · Accepted solution]

Hi @Anonymous,

You can the 'week end date' as column, 'category' as row, 'name' field with aggregate mode 'count' on value to create a matrix visual to achieve your requirement.

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you.