Forum Discussion
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 Year | WK01 | WK02 | WK03 | WK04 | WK05 | WK06 | WK07 | WK08 | WK09 | WK10 |
| FY '1516 | ||||||||||
| FY'1617 | ||||||||||
| FY'1718 | ||||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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
- v-yulgu-msftMicrosoft Employee
Hi Rajeev138,
From above steps as you described, it looks correct. If possible, please share the .pbix file so that I can check for you.
Regards,
Yuliana Gu
- Rajeev138New Member
Hi Yuliana
Thanks a lot for extending your support. Below is the drop box link for the file
https://www.dropbox.com/s/q8gkrwhlu8sdsc4/Liza%20-%202018.pbix?dl=0
Best Regards.
Rajeev
- Rajeev138New Member
Hi Yuliana,
Just want to check if you received the .pbix file share through drop box.