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.
Hello colleagues!
I often have to do similar task.
For example, we register incidents every day.
I can count incident by countrows measure, then put diagram: X axis is month and Y axis is amount of incident.
For example, 5 in January, 3 in February, 2 in March...
There is no problem if I want to view amount of incident every months.
But if i want to view number of incident from the start of the year till the end of every month:
for example January - 5, February 8 (5+3), March 10 (5+3+2) - it is very difficult.
How can I plot this graph?
Solved! Go to Solution.
Hi,
Create a Calendar Table and write the following calculated column formulas there.
Year=Year(Calendar[Date])
Month=FORMAT(Calendar[Date],"mmmm")
Build a relationship from the Date column of the base Data Table to the Date column of the Calendar Table. In your Table visual, drag the Year and Month from the Calendar Table. Write these measures:
Incidents = COUNTROWS(Data)
Incidents YTD = CALCULATE([Incidents],DATESYTD(Calendar[Date],"31/12")
Your Months on the x-axis will not be in order. Just Google for how to get months in order in PowerBI desktop and yo will be able to see the simple procedure.
Hope this helps.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |