Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
Given my data source as below - it has date column, how can I segregate this month-wise/year-wise in Power Bi?
Solved! Go to Solution.
You need to change Order Date's data type to be a Date, click the ABC and choose Date
Click close and apply and it should give you a Date Calendar in the front end.
You could also create a Calendar table using Modelling -> New Table and paste the code here in to generate a table on the fly https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
You need to change Order Date's data type to be a Date, click the ABC and choose Date
Click close and apply and it should give you a Date Calendar in the front end.
You could also create a Calendar table using Modelling -> New Table and paste the code here in to generate a table on the fly https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Perfect. Thank you. This works.
Regards
Malvika
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 42 | |
| 40 | |
| 40 | |
| 38 |