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