Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
I recreated a simpler version of your datamodel in PowerQuery:
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! 🙂
Proud to be a Super User!
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
I recreated a simpler version of your datamodel in PowerQuery:
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! 🙂
Proud to be a Super User!