Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?