Stacked bar Chart - Wrong Display

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.