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

I'm actually trying to add a row showing "Week of [Month] [Day]" above each group of dates that falls within that week starting on Monday of each week. I'm working on creating it with a macro in Excel but I'd prefer to run it all through Power BI if possible.

 

Jarrod

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

Hi jklunk ,

 

Unfortunately, according to the chart I know, there is no chart that fully meets your needs in power bi.

Or is this matrix chart the result you want?

 

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