Forum Discussion

Mheadland's avatar
Mheadland
Frequent Visitor
1 year ago
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:...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    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!

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

@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.

Mheadland's avatar
Mheadland
Frequent Visitor
1 year ago

Hi!

 

I want to display it is as a visual in PowerBI, not in the table view. 

 

How would I do this?

 

Thank you