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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38 

       

      Thank you, that worked!