I am brand new to Power BI and I wish to do the following. I have a table of open text comments from a survey, there can be one or more comment per respondent. If, after filtering the data by one or more demographic, there are fewer than 5 respondents then I wish to suppress the comments and display a message saying something like 'There are too few respondents to display any comments'. So far I have been unable to determine how to do this, can it be done? If so, how?
Would you please share some sample data in the table and expected results for our analysis?
Here is some sample data
There is a filter on the columns Gender, when no filter is selected all comments are displayed in a simple table.
If Gender=1 is selected then the following 8 comments are displayed because there are 6 unique respondents
However should Gender = 2 be selected then the following is displayed beacuse alhough there are 5 comments they come from only 4 unqiue respondents
|Too few respondents to display|
Thank you for your time.