Forum Discussion
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:
Is this possible?
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!
6 Replies
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!Thank you for your solution!
@Hi Mheadland,
Are you want to display the second picture as a Visual in Power BI? Yes we can do.
If you want to see the same data in Table View where we can see the data in Power BI desktop, it's not possible.
Please let me know if you need further help. Also please share some sample data so that I will provide exact solution.Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.Hi!
I want to display it is as a visual in PowerBI, not in the table view.
How would I do this?
Thank you
Hi @Mheadland ,
Just wanted to check if you had the opportunity to review the suggestions provided?
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
