Reply
rlsmith1994
Helper II
Helper II
Partially syndicated - Outbound

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.

 

Capture.PNG

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@rlsmith1994, you have to try as

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
rlsmith1994
Helper II
Helper II

Syndicated - Outbound

Thanks for the input! Here is the formula that worked: 

*********************************

All2 = IF (COUNT('Unit Demo Table'[Unit])=1,
VALUES('Unit Demo Table'[Unit]),
 
IF (COUNT('Unit Demo Table'[Unit])=
CALCULATE(COUNT('Unit Demo Table'[Unit]),
All('Unit Demo Table'[Unit])),
"All Units",
 
MIN('Unit Demo Table'[Unit]) & " and other "
& COUNT('Unit Demo Table'[Unit])-1 & " Units"
)
)
amitchandak
Super User
Super User

Syndicated - Outbound

@rlsmith1994, you have to try as

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)