Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

Table Visual with Various Columns

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 ...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    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! 🙂

amitchandak's avatar
amitchandak
Super User
6 years ago

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-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601