Forum Discussion

ncarrera's avatar
ncarrera
New Member
1 year ago
Solved

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:...
  • SamWiseOwl's avatar
    1 year ago

    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 ๐Ÿ™‚