Forum Discussion

Rajeev138's avatar
Rajeev138
New Member
8 years ago

Need Help in creating matrix report

 

Hi All,

 

I need to represent the weekly sales report in matrix as per the format below. Any one please help. What I have done till now is provided in the last.

 

 

FY YearWK01WK02WK03WK04WK05WK06WK07WK08WK09WK10
FY '1516          
FY'1617          
FY'1718          
Total0000000000

 

 

As I am new to Power bi, I watched few videos online on creating the fiscal calendar and related it to the sales report (with 1 to many relation) but still data is not reflecting. Not sure where I am goint wrong.

 

Here are the fields in my calendar table and Sales Report

 

Calendar (Image-1)

 

 

Calendar (Image 2)

 

 

 

Report fields (Image-1) 

     

 

Report fields (Image-2)

 

 

What I did till now is:

 

1. Created Fiscal Calendar table (though not sure if it is correct). I viewed various videos and created it.

2. Created relation (1 to Many) from calendar to sales report.

3. I inserted the "FY Year" filed of Calendar to rows

4. WeekNumberOfYear-1 to Columns

5. Volumes (Fiedl from Sales Report) in Values but it only shows me the sum total of volume instead of weekly sales.

 

This is what I get before and after adding the volume field in Values.

 

Before adding the volume field in Values.

 

 

 

After adding the volume field in values

 

 

 

 

Rajeev Mehta

3 Replies