Not sure I full understand the expectation but it this what you want?
the formula is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
If you look at worksheet, Distinct Counts are cumulative where as what i am looking for is Non-Cumulative Bar graph representation in %.