Forum Discussion
How to Create a Stacked Bar Chart for Task Progress with Multiple States?
Hi everyone,
I'm working on a project in Power BI (total newbie). I'm trying to make a bar chart to visualize the progress of tasks I'm working on.
I'll elaborate, here's how is my data structured:
Task State1 State2 Staten
Task1 Done Done
Task2
Task3 Done Done Done
Taskn Done
It's very simple, if the column Statex is not filled (normally is a Date format), the Task is not in Statex.
This is the result I'm looking for (I was made in Excel, but I wanted to upgrade):
I hope I explained myself sufficiently.
Thank you very much in advance!! 🙂
Hi ncarrera
In the Query Editor highlight the columms you DONT want to unpivot (Task etc)
Then Right click the header and choose Unpivot OTHER columns.
This gives you a table with State in one column and Done in the other.
Use this in your visuals 🙂
1 Reply
Hi ncarrera
In the Query Editor highlight the columms you DONT want to unpivot (Task etc)
Then Right click the header and choose Unpivot OTHER columns.
This gives you a table with State in one column and Done in the other.
Use this in your visuals 🙂