topic Re: Suppressing rows in a table in Report Server

Suppressing rows in a table

Nugget — Tue, 25 Jul 2017 08:58:14 GMT

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?

Re: Suppressing rows in a table

v-qiuyu-msft — Wed, 26 Jul 2017 08:26:02 GMT

Hi Nugget,

Would you please share some sample data in the table and expected results for our analysis?

Best Regards,
Qiuyun Yu

Re: Suppressing rows in a table

Nugget — Wed, 26 Jul 2017 14:45:18 GMT

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.