Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summing text columns for visual

Hi,   I'm hoping that I'm overlooking the simple solution here - but what's the best approach to sum up text values for a visual?   I have a set of data that includes 8 different skill types, whi...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, here's my solution.

    In PowerQuery, select all columns and click Unpivot, then rename the columns, get table like this:

    In Desktop, put States in Axis, Skill in Legend and Values. In the Values well, select Count, get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

According to your description, here's my solution.

In PowerQuery, select all columns and click Unpivot, then rename the columns, get table like this:

In Desktop, put States in Axis, Skill in Legend and Values. In the Values well, select Count, get the result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.