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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago
Hi jklunk,
 
Based on your description, you want the data in each row to mark the start date of each week and add the "week of" field.
You can use DAX to create a calculated column:
 
Column = "Week of "&(Sheet1[date]-WEEKDAY(Sheet1[date],2)+1)

 

You can 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.