Show text visual

[Anonymous]

Hi everyone,

I have a page which shows the results of a survey with several questions. I want to have a filter, so that you can select a specific question. But these questions are quite long, so I made a new column, where these questions are abbreviated. For example:

On a from 1 till 10 scale: How likely is it that you would recommend us to a friend or colleague? became 'NPS'. 

I still want to show the original question. When someone filters on 1 question, the original question should be visualized. When someone filters on 2 or more question, it should return a blank, because it takes too much space. 

So, something like this:

But when you select two or all three question, nothing should be returned. 

I hope someone could help me with this. 

[az38]

Hi @Anonymous 

try HASONEFILTER(), like

= IF(HASONEFILTER(Table[Question (short)]), Table[Question], BLANK()) 

[Anonymous]

Hi @az38 ,

Thanks for your reply and help. 

I tried your formula in a calculated column, but unfortunately it didn't work. 

I also tried 

test = IF(HASONEFILTER(Blad1[Question (abbreviated)]); FILTERS(Blad1[Question]); BLANK())

but without success.

[az38]

@Anonymous 

try a measure 

sorry, I didn't mention it

[Anonymous]

@az38 

No problem. I already tried measure. The measure gives an error, since you have to return a measure for the second part of the formula instead of a column:

[az38 · Accepted solution]

@Anonymous 

ok, sorry.

= IF(HASONEFILTER(Table[Question (short)]), MIN(Table[Question]), BLANK()) 

if it won't help, please show data model

[Anonymous]

@az38 

Thank you, that worked!