Forum Discussion
Create 100% stacked column chart from multiple columns
lokeshb31 , For this visual you have to unpivot this table.
https://radacad.com/pivot-and-unpivot-with-power-bi
You can have more than one measure in 100% stacked. But you can not have that on axis
lokeshb31 , For this visual you have to unpivot this table.
https://radacad.com/pivot-and-unpivot-with-power-bi
You can have more than one measure in 100% stacked. But you can not have that on axis
Sorry for late reply Amit but this suggestion worked. How we achieved it -
1. Create reference table and add Applicants column with value as Yes for all Candidate ID
2. Select Applicants, Interviewed, Offered, Hired columns and select option "Unpivot only selected columns"
3. We got Candidate ID, Attribute and value columns. We plotted attribute on axis and value in Values