Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Sadia-A
New Member

Likert format Survey Data Visualization

Hello,

I am beginner. I got a likert suery data and I need guidence in how to handle that kind of data. For Example consider a Question:"Where do you workout?" with multiple Boolean columns Where do you workout?(at home), where do you workout (outdoors), where do you workout(at gym) and where do you workout(others). there are many other questions of same type. Participants can choose multiple answers. Now If I have to show this question in a bar chart with % response.  Should I divide the data sets into different queries for each question or should I create measure to count all true rows and percentage?

1 ACCEPTED SOLUTION
Musadev
Resolver III
Resolver III

Hi @Sadia-A 
- For multiple options, you can do an analysis based on the count of each option and do the comparison. (Bar Charts)
- Based on location/age/gender you can also do an analysis based on each question.
- For binary (True/False) data, you can create measures of the total count, Yes/No counts, % of Yes/No,

For the visuals, check out these links. 
visual-vocabulary 

visual-vocabulary-2 

View solution in original post

3 REPLIES 3
Musadev
Resolver III
Resolver III

Hi @Sadia-A 
- For multiple options, you can do an analysis based on the count of each option and do the comparison. (Bar Charts)
- Based on location/age/gender you can also do an analysis based on each question.
- For binary (True/False) data, you can create measures of the total count, Yes/No counts, % of Yes/No,

For the visuals, check out these links. 
visual-vocabulary 

visual-vocabulary-2 

thank you for a prompt reply👍

qqqqqwwwweeerrr
Super User
Super User

Hi @Sadia-A 

 

Not aure about your data model. If it is columns based questioners than you can unpivot the required columns and than plot the required bar chart.

 

If you share your sample maksed data it would be easy to recreate that.

 

Regards

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.