Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show text visual

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. 

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    ok, sorry.

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

    if it won't help, please show data model

6 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try HASONEFILTER(), like

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        try a measure 

        sorry, I didn't mention it