Forum Discussion

jklunk's avatar
jklunk
Frequent Visitor
6 years ago
Solved

Adding rows to group by weeks

I'm creating a report pulling data from Salesforce, and I'm trying to add rows that will group data by each week. These obviously need to update each week the report is run. I created a field from th...
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi jklunk ,

     

    You can use the Matrix chart and place the date column and the weekly start date column in the rows of the chart.

    Again,please refer to the pbix.

     

    Best Regards,

    Liang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jklunk's avatar
jklunk
Frequent Visitor
6 years ago

This matrix could possibly work, if I could get the details showing to the right (no need for count or sum). How did you create that matrix?

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jklunk ,

 

You can use the Matrix chart and place the date column and the weekly start date column in the rows of the chart.

Again,please refer to the pbix.

 

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jklunk's avatar
    jklunk
    Frequent Visitor
    6 years ago

    Liang,

     

    This is excellent. One issue I'm having is that it it is consolidating anything with the same due date into one line so I'm losing dating. I'm new to Power BI, so I'm guessing there is an easy way to change this to show all even if Bid Due Date is the same?

     

    Thanks,

    Jarrod