Hello,I have one table of a survey and I have two columns that are open responses. I would like to be able to do an analysis of the responses (Text) in which they can be grouped by subjets or topics.The thing is that I don’t know the subjets or topics previously, the Power Bi have to do it by itself.Do you know there is any visualización or if I can do it in any other way?Thank you in advance,

Hi, Cin Based on your description, you want to analyze survey responses in Power BI by automatically grouping them into topics or themes. So far, Power BI does not have built-in functionality for automatically analyzing text data and categorizing it into topics. You can submit an idea for here and the product team will take note of such a need. Related Link: New tab (powerbi.com) However, this can be done by integrating Power BI with Azure Cognitive Services or by using a custom script in Python or R to perform text analysis before importing the results into Power BI for visualization. Here are the steps on how to perform text analysis and group survey responses by topic: 1. Preprocess the survey data to clean up the text data in the Power Query editor by removing any unnecessary characters, spaces, converting all text to lowercase, and so on. 2. Use Azure Cognitive Services (specifically the Text Analytics API) to analyze the text and identify key phrases or topics. Alternatively, you can write Python or R scripts to perform topic modeling using libraries such as NLTK or Gensim in Python or the and package in R. Azure Text Analytics API link: Azure AI Language | Microsoft Azure3. Import the processed data into Power BI as a new dataset or merge it with an existing dataset and then create visualizations in Power BI. Best Regards,YangCommunity Support Team If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot! How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Text analysis that returns the information grouped by topic

Forum Discussion

Related content

Cohort analysis

Retention analysis

Rest API Informations

Merge queries only returning partial information

Missing information