Top 3 Survey Visuals in Power BI

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.

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!

Very good. Every time I watch your videos I learn as much about presenting as I do about Power BI

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 :-(

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.

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!

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

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.

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

Excellent! I love your sharing so much!

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....

Awesome approach, thanks! I'm going to use the first one in my personal finance dashboard to show the budgetted amount per category

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.

Another great video. It is always a pleasure to watch Bas. You are both knowledgeable and entertaining.

I like the first option, as appears, to me, to be clearer. Great video though. thanks Paul

superb, thank you for sharing

Once again, very useful video. thank you.

Thank you very much, it is very intuitive, 🙏🙏

Excellent! Love the CF measure trick.

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.