Stacked Bar Chart (100%) using filtered Count

[klrameet]

Hi

I have this stacked bar chart that i am trying to convert into 100% bar chart and having difficulties pulling up count by total for this.

Dimensions:

Stack: Team

Bar: =IF(NOT MATCH(State,'Closed','Resolved'),State)

Measure:

Count({<Aging=>}Number) //This is taking the count ignoring the filter at Sheet level & Works fine for regular stack bar graph

But when i try to change this for 100% Bar graph, my bars are shown with 0 & 1 instead of actual %

Count({<Aging=>}Number)/Count({<Aging=>}Total <Team> Number)

Appreciate the guidance here.

[Nicole-Smith · Accepted solution]

On your measure on the chart, make sure the number formatting is set to number then in the dropdown make sure you select one of the percentage options.

[klrameet]

That did the trick .. Thank you @Nicole-Smith