Create a Stacked Column Chart Help

[Anonymous]

Hey all,

Forgive this messy question, I'm not sure how to word it, or provide very good examples of what I'm trying to create.

My data sheet includes year, state, and strain (among several other pieces of information, with irrelevant stuff removed/filtered out)

I would like to create a stacked column chart. I want "State" to be on the X axis, and the column to be comprised of the different strains. So if Delaware had (these are random numbers that don't match the pictures) 7 occourances of strain 1, 4 occurances of strain 2, and 1 occurance of strain 3, i want that to tranlate into 100% of Delaware's samples. 

I was pretty close to having what I needed, but it wasn't quite right, and now I'm stuck again.

I've attached a paint picture of what I'm trying to accomplish.

I've looked at some previously answered questions similar to mine, and one of them said something about unpivoting my data...but it was never pivoted to begin with? And I don't fully understand what pivoting/unpivoting even does.

ETA: I want the chart to be able to "count" the occurances of each strain by the state. I have measurements up the wazoo, but can't efficiently create the visual I want.

[Anonymous]

Thank you @TheoC !!!

[TheoC]

Absolute pleasure @Anonymous 

Have a great day!

[TheoC · Accepted solution]

Hi @Anonymous 

Can you try the following:

1. Create a new measure (Measure = COUNTROWS (TableName)

2. Drag the visual on to your Power BI Canvas.

3. Place "State" on x-axis

4. Please Strain in Legend

5. Drag Measure into Values.

Should give you what you want.

Hope it helps.

Theo