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 ...
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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

        Anonymous 

        ok, sorry.

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

        if it won't help, please show data model