Top 3 Survey Visuals in Power BI
Vložit
- čas přidán 7. 07. 2024
- Join my Power BI Design training here: my.datatraining.io/pages/powe...
Visualizing survey data isn't as straightforward as any other standard dataset like sales. In this video I show you 3 different visuals and how to get survey data into the right shape.
Enjoy and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
* visual 2 shows a minus sign in front of the % of bad/very bad answer options. To fix this choose the chart type to stacked bar chart and set the measure formatting to 0%; 0%
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:20 Getting your survey data in the right shape
07:53 Survey visual 1
15:23 Survey visual 2
19:00 Survey visual 3
23:52 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Věda a technologie
Your knack for creative exploration is remarkable. It's like seeing a single visual through different lenses, helping us pinpoint the perfect solution. Your dedication to this process ensures we always achieve excellence.
Very good. Every time I watch your videos I learn as much about presenting as I do about Power BI
☺️thanks
Hi Bas, thank you for this. It helped me transform the reporting of performance review distributions by demographics. If you have any ideas on how to demonstrate staff movement between internal departments, I think a lot of HR Analysts would be grateful! Love all your videos
Thank you very much, very rich information that could be used for other applications...
Also appreciate very much your way of presenting the illustration, may God bless your heart!
I prefer the second one, just wanted to add a constant iline in the middle as it is not understood easily at first
Hi Bas, thank you for the video - visuals are looking neat and your videos are always very informational! Would love to see more survey based videos! Just to let you know, when you structure your data this way, you miss out on one of the key awesome features that power bi visualizations offer -> drilling down. One of the key insights that survey visuals can provide, is to answer questions such as "How do people that rate Comfort 'Very bad' score on other parameters?". Is comfort an "isolated" issue, or are people who are dissatisfied with comfort also dissatisfied with the facilities, the price, etc. If you think the price was too high, what was it in relation to? If you had an "overall satisfaction" question - which areas affect the overall experience the most, where should you put your efforts to create a better overall experience? With that in mind, if you create more survey answers related videos, I would be very happy! Surveys in PBI is generally not an area with enough content in my opinion!
Thinking it through, I reckon you could create slicers to allow users to view relationships in that way. But if you have a neater solution, I would be all ears! Thank you again!
Cool video, I will grab some tricks from this!!
Past week I had been making the same visual result but in another way. In my case the core table has A LOT of this type of likert questions, so I duplicate the core table and then insolated each one, after that appling unpivot operation.
Later I throuws Attribute in Y and Value in X and legend.
Finally I make a SINGLE calculated measure for each table to make the % appear at DATA LABELS. The DAX I use is this one:
example =
ROUND(DIVIDE(COUNTROWS('Question_x'),
CALCULATE(COUNTROWS('Question_x),
ALLSELECTED('Question_x)))
*100, 1) & " %"
The process ends up as the same but it took less measure creation
How do you always know what I'm working on and provide the solution I'm looking for? This has come at the right time. Thank you!
I like the conditional formatting measure!
Excelent class. I prefer the first option, I think is easier to understand, however, it's good show more options to the end users beacuse in the end, they decide what they want to see.
Great Video! After some consideration i came to the conclusion that i like the second chart option the most, with the shifted bars. Because if i wanted to find i out which areas performs the worst and i looked at option 1, i might be tempted to think its Location, Staff and Money, due to the very bad percentages, are the highest in those categories. However, when i take a look at option 2, it becomes clear that the overall result returns Staff, Money and Comfort as the worst performing, while Location is actually up to a second overall place. The 3 option, i felt also was good to break down each answer respondent by categories, though i felt it lacked the overall picture option 1 and option 2 have
Another great video. It is always a pleasure to watch Bas. You are both knowledgeable and entertaining.
This was amazing Basssss!!! Thank you so much!
😁🎉 thx!
Excellent! I love your sharing so much!
Another great video, Bas. For me chart no.2 is the best.
Thanks a lot
you are always doing amazing , thanks a lot for usual support and give us the new tips and tricks in PowerBI , great job brother keep it up.
3rd option for me. Much easier to read and I like the formatting, clean and easy on the eye.
😁 it seems that a lot of people have a different preference on this one, .. tricky
Great content! Thanks! #2 is definitely the least readable. It didn't pass the 5 second rule for anyone on my team when I showed the screenshot. Depending on space I'd go 1 or 3 leaning towards 3.
Thanks for sharing. all three interesting charts. Natural instinct is to go for the top left one but I also liked the third one to compare categories for a given response.
Excellent video and very insightful I would go for the 3rd option as that easier to read and understand, keep making videos like this as its very helpful....
As usual an extremely goo video. Thank you for your efforts.
I would pick the graph #2, very readable to me
Hi Bas, I would prefer the second. But a likkert scale has 5 (or 7) options. I had a student splitting the middle (3) scale into two parts. Quite some work in Excel, but after seeing your video this is doable in Power BI, for example: 3Right = 0,5 x "3" and 3Left = -0,5 x "3". Another remark: at presenting your survey results you should always present n = 30 (where 30 is the number of respondents), this can be different per question. My ultimate graph survey graph would also take this into account, meaning that the surface of the bar would reflect the number of respondents.
Awesome approach, thanks! I'm going to use the first one in my personal finance dashboard to show the budgetted amount per category
Thanks ☺️ have fun implementing
superb, thank you for sharing
Thank you very much, it is very intuitive, 🙏🙏
Once again, very useful video. thank you.
Excellent! Love the CF measure trick.
That fx button makes me happy every time i see it 😆😁
Perfect timing …. I am working on similar project 😊
I could feel it 🙃😉
I like the first option, as appears, to me, to be clearer. Great video though. thanks Paul
Good Job Done! Thanks!!!!
😎👊
Very cool, thanks Bas
I love it, thanks again Bas !!
Happy to hear that , thx for watching again!!! 😃
Thanks for making a stats video!! More please!! :-) I work with stats all the time...
By the way... at 2mins 12seconds you mentioned another video about unpivoting - I didn't see the link to this :-(
Thanks for vid, superb. I'm very enjoy it.
😎👊
Fantastic, i like all options...kkkk...
Nice video 🎉
Just finished project of survey (used the 1st option )now I need to go back right the sketch up table 🤣 to see if the other chart can benefit the end user
Oooor you pretend you didnt see the video and save yourself the work 😆
Awesome, nice video. Thanks for sharing
Thanks for watching! 😃
amazing
That’s actually very funny, on my job I got a servey data for visualization and for now I have already cleaned and prepared the data, but haven’t started doing graphs and… This video has been just uploaded, crazy:)
I think it is survey time of the year!!! this is the 3d comment that somebody just started working on some survey data lol 😂
hope you create trouble ticket and CRM dashboard with KPI calculations! thank you Mr. Bas!
Great video however instead of building measures I just build another table with the answer categories (ie. new table that show 4- good thru 1-very bad) that way you can build a relationship with multiple categories that use the same answers
I prefer the first one. Others are informative also though.
Very nice, it would be nice also to get in the sum of “positive” (good+very good) and “negative” (bad+very bad) in the visualization in some way 🙂
Ah you could actually place those percentages outside of the bars with a dummy that you make invisible
Please create a video on summarized page or an overview page which takes important information from other pages
thx for the idea
Great tutorial! I've been doing the second version for a while, however, I see you have the same issue which is that the diverging bar sort order doesn't match the legend sort order.
Yea saw that too after i recorded it lol 😆 , bit annoying but still kinda ok.. i didnt come up yet with an elegant way to fix that
@@HowtoPowerBI I think it's more annoying as you can get the same visual as a default in Microsoft Forms. Obviously without any of the other cool functions
In Visual type 2, how do you sort the legend in the correct order? So: Very Bad - Bad - Good - Very Good
Really nice video as always. However, I miss a best practice data model to structure survey data if you have the requirement of being able to cross-filter/cross-highlight questions. I can't see how you can do that with your example here.
For instance, you have two visuals. Visual A shows the answers for question A while Visual B shows the answers for question B. Both visuals have a visual-level filter on "Question" (A/B respectively). If you click on a specific answer of one of the visuals, you won't be able to see the combined answers, as both visuals are filtering on "Question" differently.
I really lack a way to solve this. Do you have a proper solution for this?
Thanks in advance and love your content btw
hey bro.. i didn't get the dataset ..could you provide link in the chat section..
It is already in the description
Hi bass, why u multiplied with -1
for the "negative" bars to go to the left
i can't able to download the data set
What error do you get
Survey projects are not that easy... A lot of data transformation is required... Most of the time surveys capture results in online sheets like google form or smartsheet... I just completed my second survey project, so I know...😅