Stacked bar Chart - Wrong Display

[Anonymous]

Hi Community, hope you are doing well. 

I am bulding a PowerBi project for work and I am facing the following issue when it comes to display. 

Currently I am getting all data from a excel sheet that look like this: 

I want to create a stacked bar chart showing the orange columns (failure cases) sum for every column. When I try to build this in PowerBi I am getting the following: 

I would like to show in the stacked bar chart for every row what is the failure case (i.e. location) and how many cases we had (this means the sum of the column).  I do not know what to include in Y-axis to show this infromation. 

[Anonymous · Accepted solution]

Solved. I just unpivot those columns.  Thank you very much. 

[amitchandak]

@Anonymous , Add row ID or unique row column on Y-Axis , You need have some field on Y axis for that

[Anonymous]

I have created other table with Y axis values: 

Now when I add Failure cases columns I am getting this: