Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rlsmith1994
Helper II
Helper II

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

@rlsmith1994, you have to try as

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

Share with Power BI Enthusiasts: 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

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

@rlsmith1994, you have to try as

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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