Forum Discussion
Summing text columns for visual
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.
Hey Anonymous ,
How does your sample data look like?
If the table provided i your original post the expected outcome?
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.