Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I want to draw a stacked column chart like this
But my data is not suitable for this. First table is a sample from my data.
Above is the table that i want to create. I think i can draw the graph if i can create a table like this:
I'm a beginner in PowerBI so I'm really confused. Are there any DAX or M codes or any other method for creating a column like that? Or any other method to draw the graph? Thanks for your support 🙂
Solved! Go to Solution.
@selinozdemir , 1 .Unpivot all 4 column other then ID
2. Split the column by delimiter into 2 columns, so blue/ white, man/women separate out (The format you need a copy of the column before you split, I do not prefer that)
3. Pivot again with complete column you kept as backup
https://radacad.com/pivot-and-unpivot-with-power-bi
@selinozdemir , 1 .Unpivot all 4 column other then ID
2. Split the column by delimiter into 2 columns, so blue/ white, man/women separate out (The format you need a copy of the column before you split, I do not prefer that)
3. Pivot again with complete column you kept as backup
https://radacad.com/pivot-and-unpivot-with-power-bi
Thank you so much 😊
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |