Table Visual with Various Columns

[jcastr02]

I'd like to set up a "Table" Visualization as per below screen shot.  The top is what my query currently looks like in Query Editor, but Id like my visual to be set up as shown in the bottom part of the screen shots.  (showing how many strongly agree, agree, neutral, etc.).  I have tried to unpivot some of the columns but haven't found solution.  Any suggestions would be appreciated.  

[amitchandak]

Try this, create a new table using union and summarize

new Table = union (
summarize([First Column name], "New col heading" ,"First column name")
,summarize([Second Column name], "New col heading" ,"Second column name")
,..
,..
)

Here "First column name" is a text that will create the first column of the second table name as "New col Heading"

[First column name]  is basically the name of the column-like 'TableName'[column Name]

Once get the table rename the first column and then you can use this table for further analysis.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[JarroVGIT · Accepted solution]

I recreated a simpler version of your datamodel in PowerQuery:

Original column

Then I select all columns and hit Unpivot Columns, resulting in:

Change the column names (not required) to Statement and Response. Click Apply & Close and return to PBI Desktop. Create a Matrix visual with Statement as rows, Response as Columns and Response as Values. Change the Response (in Values) to Count, and show the result as percentage of row total like this:

Hope this helps you out  🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂