Forum Discussion
Group by week measure
Hi Guys,
Could I ask what would be the best way to group a matrix by week number as per my attached image. I would like just one line entry I.e. week 1, week 2 and then the weekly totals next to them.
Thanks in adavance.
Hi Hodgey87 ,
Drag the matrix visual and set like:
Rows -> Week
Values -> Weekly Total
It will work with this table in the picture if you remove the date column and Weekly Total is set to aggregate the values.
Ricardo
3 Replies
- ibarrau
Super User
Hi. If you want the value aggregated by week just remove the date of the column and Power Bi will be able to do it. You can build a matrix with week as rows and add the values summarized that you want under Values.
Regards,
camargos88Community Champion
Hi Hodgey87 ,
Drag the matrix visual and set like:
Rows -> Week
Values -> Weekly Total
It will work with this table in the picture if you remove the date column and Weekly Total is set to aggregate the values.
Ricardo
- amitchandak
You need to create a weekly calendar(Or add week in date calendar) and then do it.
Refer:https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
