Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Absolute pleasure @CosmicHorse95
Have a great day!
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
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
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |