Forum Discussion
Suppressing rows in a table
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 ...
Hi Nugget,
Would you please share some sample data in the table and expected results for our analysis?
Best Regards,
Qiuyun Yu
Hi,
Here is some sample data
| RespondentID | Gender | Comment |
| 1 | 1 | Aaaaa |
| 2 | 1 | Bbbbb |
| 3 | 2 | Ccccc |
| 4 | 1 | Ddddd |
| 5 | 2 | Eeeee |
| 6 | 2 | Ffffff |
| 6 | 2 | Ggggg |
| 7 | 1 | Hhhhh |
| 8 | 1 | Iiiii |
| 8 | 1 | Jjjjj |
| 8 | 1 | Kkkkkk |
| 9 | 2 | Llllll |
| 10 | 1 | Mmmm |
There is a filter on the columns Gender, when no filter is selected all comments are displayed in a simple table.
| Comment |
| Aaaaa |
| Bbbbb |
| Ccccc |
| Ddddd |
| Eeeee |
| Ffffff |
| Ggggg |
| Hhhhh |
| Iiiii |
| Jjjjj |
| Kkkkkk |
| Llllll |
| Mmmm |
If Gender=1 is selected then the following 8 comments are displayed because there are 6 unique respondents
| Comment |
| Aaaaa |
| Bbbbb |
| Ddddd |
| Hhhhh |
| Iiiii |
| Jjjjj |
| Kkkkkk |
| Mmmm |
However should Gender = 2 be selected then the following is displayed beacuse alhough there are 5 comments they come from only 4 unqiue respondents
| Comment |
| Too few respondents to display |
Thank you for your time.