Forum Discussion
Solved
Grouping Dates by Month
I hace recently created a date table in my PowerBI, it currently looks like this: I am wondering if there is a way for me to group the dates and weeks by month so that it looks more like this:...
Hi Mheadland ,
Yes, you can achieve this by formatting the Matrix visual in Power BI.
You can follow these steps-
1. Create a column -Month-year = FORMAT('Table'[Date],"MMM") & "-" & FORMAT('Table'[Date],"YYYY")
2. Create a column for week number-
Week = WEEKNUM('Table'[Date])
3.Add Month-Year, Week and Date from the table to Rows in the Matrix
4. Drill-through your matrix and format it with Outline Layout and Condensed Style.
5.Remove +/- icon under Row header
You will get the result-
Attached file for reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!
Hi Mheadland ,
Yes, you can achieve this by formatting the Matrix visual in Power BI.
You can follow these steps-
1. Create a column -
Month-year = FORMAT('Table'[Date],"MMM") & "-" & FORMAT('Table'[Date],"YYYY")
2. Create a column for week number-
2. Create a column for week number-
Week = WEEKNUM('Table'[Date])
3.Add Month-Year, Week and Date from the table to Rows in the Matrix
4. Drill-through your matrix and format it with Outline Layout and Condensed Style.
5.Remove +/- icon under Row header
3.Add Month-Year, Week and Date from the table to Rows in the Matrix
4. Drill-through your matrix and format it with Outline Layout and Condensed Style.
5.Remove +/- icon under Row header
You will get the result-
Attached file for reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!
Thank you for your solution!