Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an excel file with thousands of questions in it. I am trying to find the trends in these questions and want to build a report that shows common phrases, or frequently used words. i.e. cell = question 'what is your annual revenue?'; 'what is your % of revenue by vertical?'
With this data can Power BI return a report showing that there are 2 instances of the subject revenue being asked by a customer?
Solved! Go to Solution.
Hi @c5vette211,
Suppose there is a column listing all questions in your source dataset, as shown below.
I suggest you create an extra table to list some phrases or words that might be frequently used in questions, like below. Later, you should add this column into a slicer for users to choose.
Create measures:
check = ISERROR ( FIND ( SELECTEDVALUE ( Dataset2[Selection] ), SELECTEDVALUE ( Dataset1[Question] ) ) ) count = CALCULATE ( COUNT ( Dataset1[Question] ), FILTER ( ALLSELECTED ( Dataset1 ), [check] = FALSE () ) )
Best regards,
Yuliana Gu
Hi @c5vette211,
Suppose there is a column listing all questions in your source dataset, as shown below.
I suggest you create an extra table to list some phrases or words that might be frequently used in questions, like below. Later, you should add this column into a slicer for users to choose.
Create measures:
check = ISERROR ( FIND ( SELECTEDVALUE ( Dataset2[Selection] ), SELECTEDVALUE ( Dataset1[Question] ) ) ) count = CALCULATE ( COUNT ( Dataset1[Question] ), FILTER ( ALLSELECTED ( Dataset1 ), [check] = FALSE () ) )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |