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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper III
Helper III

How to Group Data / Visualise


I have a survery that users fill in. In one of the questions, they are given the option of free text box where they can express their views on the given topic. E.g Why are you not satified with your working arrangements?


Users populate the form with lots of text expressing views such as, complaints about management, not being able to work from home, tea and coffee machine broken, issues in the office, etc - the responses are varied and users can type upto 2000 characters. 


I need a way to group this or find a way to easily report on this response. 


I tried using Text Analyics feature in Power BI Desktop to extract Key Words - but its failing to extract the key words which i think are key. 


What is the best way to report on this data. I was thinking if it was possible to group this data in buckets - so can we automate a way to say "this response is refering to working from home, so tag it as working from home", or this response is issues with management, so tag it under 'management issues' tag. 


Then i can just report on the tags.  Is this possible, if so, what is the best way to acheive this. 


hope that made sense. 


Any help will be beneficial. 



Community Support
Community Support

Hi @PPStar ,

One way to group the free text responses is to use key phrase extraction. Power BI has a built-in key phrase extraction feature that can extract the most important phrases from unstructured text. You can use this feature to extract key phrases from the free text responses and then group the responses based on the key phrases.


To use the key phrase extraction feature in Power BI, you can follow the steps outlined in the tutorial "Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn".


How to Get Your Question Answered Quickly 


If it does not help, please provide more details.


Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




as stated in my original post, i have tried to use this, but it does not give the results i want. 

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors