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

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
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! 🙂