Forum Discussion
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...
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
I'm not sure I follow you? The table in my original post is what this section of my data looks like, but the outcome desired is a graph
I have tried to create a visual as per my understanding of your requirement.
See if it solves your purpose.