Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Value Count after Unpivot Columns is not unique

I have some employee data in Excel table containing experience and software skills. I applied Unpivot Columns of both Experience and Software Skills separately and plotted them. The percentage/propor...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Step1: unpivot the year columns.

Step2: filter experience column which value is blank.

Step3: unpivot the software columns.

Pbix as attached.

 

Best regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks. Any suggestions for the case when I have multiple such unpivoted headers and their values?