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.
Hi
Im trying to create a column chart which displays the number of tasks per month that have a shipping date relevant to that month.
I have 1 table called tasks. In tasks i have task name and task finish date. I cant get it to sum the values, in pic u can see it puts the months next to each other Also i have specific dates for each finish date, so i have in power bi changed these values to be a month field.. i dont need cumulative i just need to show how many projects have finish dates in that month for specific tasks.
thanks in advance 🙂
N
Solved! Go to Solution.
Have you tried to create a calculated column based on the specific date and create a column chart based on the shipping month.
shipping month = DATE(YEAR(Task[ShippingDate]),MONTH(Task[ShippingDate]),1)
Have you tried to create a calculated column based on the specific date and create a column chart based on the shipping month.
shipping month = DATE(YEAR(Task[ShippingDate]),MONTH(Task[ShippingDate]),1)
thankyou - i was able to add a grouping to the date on x axis- which allowed me to create a bin which i selected per month (voila!!)
So isn't adding a grouping work for you now? If not, could you be more specific? I don't get too much idea from the original post.
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.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |