Forum Discussion

rlsmith1994's avatar
rlsmith1994
Icon for Helper II rankHelper II
5 years ago
Solved

Display 'All' and multiple from slicer results

I have a report with a text box being used as a title. The title is based on a specific unit selected in a slicer. Individuals can select their unit and view the individual reports. So if a unit sele...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @rlsmith1994, you have to try as

    if(isfiltered(Table[col]) Count(Table[col]) >1 , "All", selectedvalue(Table[Col]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

@rlsmith1994, you have to try as

if(isfiltered(Table[col]) Count(Table[col]) >1 , "All", selectedvalue(Table[Col]))