Create 100% stacked column chart from multiple columns

[lokeshb31]

Hello Everyone,

We have a requirement to display below data on 100% stacked column chart

Candidate_ID is nothing but Applicant here, all applicants should get displayed on chart like below, but I am not sure how to fit all above columns into axis to divide them as per region. I tried to create new table in Power query editor, also tried to create using UNION DAX query but thats not working.

Please provide your inputs. 

[amitchandak · Accepted solution]

@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]

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