Filter clustered bar chart based on value

[RGSRS]

Hi,

New guy in town.

I wanted to make a graph based on a list of values. The list is something like this:

A

B

A,C

A,B,C,D

D

B,A

so the values come up more than once. When I do the graph, they will appear once bar per line but I wanted to have a graph where what showed up was a count of the number of As, Bs, Cs, etc...

Is this possible?

Thanks!!

Ricardo

[parry2k · Accepted solution]

@RGSRS you need to split the data in power query and then you can easily do it.

Solution attached. Would appreciate Kudos 🙂 if my solution helped.

[RGSRS]

Thanks - works great!

Ricardo