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,
I have this issue with my report. I have tasks with 4 statuses and dates when they got into each one. (They can skip some of them)
I need to make a stacked area chart which show me evolution of counts of these tasks. (in which time how manz was in status 1,2,
3 and 4 )
Thanks you so much for your help!
Solved! Go to Solution.
@grofdaniela wrote:
Thanks @kaushikd,
but I need time on X axis and need to see that for ex. at May 6 i have 2 tasks in Status 1 (A, E), then at May 13 I have 2 (B, E) in Status 1 and 1 in Status 2 (A changed from status 1 to status 2).
You need to unpivot your table and create a visual with the new table. See more details in the attached pbix file.
Hi @grofdaniela
I have taken your data as refference
What you have to do is to create 4 column with these Dax formulae.
#1 DayCount = DATEDIFF(TaskStatus[Status 1],IF(ISBLANK(TaskStatus[Status 2]),IF(ISBLANK(TaskStatus[Status 3]),IF(ISBLANK(TaskStatus[Status 4]),today(),TaskStatus[Status 4]),TaskStatus[Status 3]),TaskStatus[Status 2]),DAY)
#2 DayCount = IF(ISBLANK(TaskStatus[Status 2]),BLANK(),DATEDIFF(TaskStatus[Status 2],IF(ISBLANK(TaskStatus[Status 3]),TaskStatus[Status 4],TaskStatus[Status 3]),DAY))
#3 DayCount = IF(ISBLANK(TaskStatus[Status 3]),BLANK(),DATEDIFF(TaskStatus[Status 3],IF(ISBLANK(TaskStatus[Status 4]),TaskStatus[Status 3],TaskStatus[Status 4]),DAY))
#4 DayCount = IF(ISBLANK(TaskStatus[Status 4]),BLANK(),DATEDIFF(TaskStatus[Status 4],TaskStatus[Status 4],DAY))
Now your data will look like this
Now you can built your chart as i have done
Please mark this as a solution if this is what you needed...
Thanks @kaushikd,
but I need time on X axis and need to see that for ex. at May 6 i have 2 tasks in Status 1 (A, E), then at May 13 I have 2 (B, E) in Status 1 and 1 in Status 2 (A changed from status 1 to status 2).
@grofdaniela wrote:
Thanks @kaushikd,
but I need time on X axis and need to see that for ex. at May 6 i have 2 tasks in Status 1 (A, E), then at May 13 I have 2 (B, E) in Status 1 and 1 in Status 2 (A changed from status 1 to status 2).
You need to unpivot your table and create a visual with the new table. See more details in the attached pbix file.
Hi,
thank you very much, however, i solved this task few days ago by myself 🙂
him how did you fix this?
was there an alternative method then previously advised by other members?
him how did you fix this?
was there an alternative method then previously advised by other members?
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |