Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Categorize data by week number using by date

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.

Tutorial Requests

Anonymous
3 years ago
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

4 Replies

amitchandak
Super User
3 years ago
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
  Not applicable
  3 years ago
  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
    Not applicable
    3 years ago
    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

Related content