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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
cmilligan262
Helper II
Helper II

Only allow selection of certain values in slicer

I'm wondering if there's a way to only allow certain selections in a slicer.

 

For example I have a financial dataset with a scenario field. It is populated with either a forecast, actual,or budget from a date.

 

Is there a way I can only allow selection of actuals from the slicer.

 

Thank you.

2 REPLIES 2
Anonymous
Not applicable

Hi @cmilligan262

I tried to understand what you described in the case, but I still don't quite understand what kind of slicer you wants in the end . Could you please provide some sample data and the screenshot of expected results ? I created sample visual just like below, but I don't think this is what you want...

get certain value from slicer.JPG

 

Best Regards

Rena

nhoward
Resolver I
Resolver I

HI @cmilligan262 

 

If you only want actuals on the whole report page, you can apply a Page Filter.  This is within the Filter Pane toward the bottom.  

 

If you only want actuals within a visual you can apply the filter within the filter pane.

 

both options remove the need for the Slicer. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors