Forum Discussion
Calculated Column return column Header Title if a condition is met - ie cell has a 1 in it.
Hi Anonymous,
As amitchandak said, do unpivot columns on your '# option' fields to convert them to attribute and value. Then you can create a matrix visual with name on 'row', value on 'column', attribute on value field to achieve your requirement.
Regards,
Xiaoxin Sheng
Anonymous , The data is not making it clear.
I think Unpivot or transpose should help you to put data in a better format
https://radacad.com/pivot-and-unpivot-with-power-bi
https://yodalearning.com/tutorials/power-query-helps-transposing-data/
attempt #3
current data set...
Survey Question. From the 5 options, rank your Top 3 challenges whilst working from home? Name #1 Option #2 Option #3 Option #4 Option #5 Option Employee 1 2 3 2 Employee 2 1 2 3 Employee 3 3 1 2 I'd like to have a calculated Column for each Ranking... ie #1 challenge, #2 Challenge and #3 Challenge reflecting the Option selected by the Employee.
Using the data set above, the calculated colums would look like the following:
Employee Name
#1 Challenge #2 Challenge #3 Challenge Employee 1 #5 Option #1 Option #3 Option Employee 2 #2 Option #4 Option #5 Option Employee 3 #2 Option #3 Option #1 Option third times a charm ??
Tim
Hi Anonymous,
As amitchandak said, do unpivot columns on your '# option' fields to convert them to attribute and value. Then you can create a matrix visual with name on 'row', value on 'column', attribute on value field to achieve your requirement.
Regards,
Xiaoxin Sheng