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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors