- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 selects "philosophy" in the slicer, "philosopy" shows up in the text box and is used as the page title.
Individual units also want to see a report with all the units combined. However, the title defaults to the first unit listed in the slicer (in this case, 'creative technologies programs').
Is there a way to set the text box (or table, card, whatever) to display 'all units' or even just 'all'? Or if multiple units are selected? Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@rlsmith1994, you have to try as
if(isfiltered(Table[col]) Count(Table[col]) >1 , "All", selectedvalue(Table[Col]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for the input! Here is the formula that worked:
*********************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@rlsmith1994, you have to try as
if(isfiltered(Table[col]) Count(Table[col]) >1 , "All", selectedvalue(Table[Col]))

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-07-2024 07:16 AM | |||
07-23-2024 01:10 AM | |||
04-02-2024 08:11 AM | |||
Anonymous
| 03-26-2024 01:18 PM | ||
12-13-2023 05:17 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |