Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Date/Time column which I want to filter on. However, when I try to filter it lists each day individually. However I want to group these by Month.
For example I want to Count number of Column A in July.
This must be simple but it is listing the count of Column A for each day and I can't figure out how to group these by month.
PS, I couldn't view the individual boards so had to select Service.
@liam You can use DAX time intelligent functions given in below link to create custom columns and then sort as per required
You can try add a calculated column with function =MONTH(YourDateColumn) and then drag this column to group. Minus is that the moths are view as numbers( july = 7 ). Or you can try STARTOFMONTH(YourDateColumn) which when you drag it to a graph it usually has months as axis.
Table choose months , graph choose startofmonth
Hello,
I found out how to do this in an easier way.
1. Edit Query
2. Take the Date column you want and Duplicate it in the Transform Tab
3. In the Transform Tab under Date & Time Column Select Date drop down
4. Delect Month > Name of Month
This worked for what I was trying to do.
I tried that & it worked but unfortunately it wont allow me to save it because it
cannot make the changes on a live connections :-(. Any work around for live connections(I am using Direct Query)
I've got the same problem; did you fix it? Thanks in advance.
Hello,
I found out how to do this in an easier way.
1. Edit Query
2. Take the Date column you want and Duplicate it in the Transform Tab
3. In the Transform Tab under Date & Time Column Select Date drop down
4. Delect Month > Name of Month
This worked for what I was trying to do.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.