Reply
Rollingdip
New Member
Partially syndicated - Outbound

Likert scale or rating vizualization

I have questions of rating from 1 to 4. I have connected Kobo toolbox to Power Bi.

Rollingdip_0-1734518681828.png

As you can see, 1.2 to 1.7 responses in 1 to 4 scale, and have around 60 rating questions.

[1, "Early Stage",
    2, "Foundation Stage",
    3, "Well-Developed Stage",
    4, "Mature Stage"]
How do I vizualize that in matrix as shown below?
Rollingdip_1-1734518841427.png

How do the all Questions appear in rows and values in column?
How shall I move ahead? Unpivot is only options to bring all question in rows?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Syndicated - Outbound
Unpivot is only options to bring all question in rows?

yes, very much yes.  This is one of the fundamental processes of Power BI ETL.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Syndicated - Outbound
Unpivot is only options to bring all question in rows?

yes, very much yes.  This is one of the fundamental processes of Power BI ETL.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)