How to Create a Stacked Bar Chart for Task Progress with Multiple States?

[ncarrera]

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!! 🙂

[SamWiseOwl · Accepted solution]

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 🙂