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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
hprose
Helper I
Helper I

Default slicer values for field parameters

Hi everyone, 

 

I've created dynamic slicers using field parameters using this tutorial which works great functionality wise. It allows me to dynamically change legends so I can compare different values against each other. However, I have a line chart instead of the column chart shown in the tutorial screenshot below. And imagine I have over 100 stores and 100 product categories. So when I switch between them I have over 100 lines in my chart before I can select a few I want to compare.

 

Is there any way I can have the second slicer in the example have 2 default values selected which the user can then change? For example: Amsterdam Store, Catalog Store selected by default when Store is selected in the first slicer and Product 1, Product 2 selected in the second slicer when Product Category is selected in the first slicer. Note, that both these slicers are coming from a field parameter.

Dynamic Slicers with Field Parameters.pngDynamic Slicers with Field Parameters 2.png

Thanks!

2 REPLIES 2
hprose
Helper I
Helper I

Hi @amitchandak , thanks for your response. I already have the slicers I need created from a field parameter.  I'm dynamically changing the legend based on slicer selection, not the axis. I can also do a comparison of 2 or more variables just fine. The issue is the default selection of over 100 values in the slicer when nothing is selected. By default I want the slicer to have 1 or 2 options preselected instead of everything. Bookmarking or saving the file is not possible since I have 5 different slicers. Here's a mockup of what it looks like since I can't share the data unfortunately. 

I have a single field parameter and it's copy acting as slicers. 1st slicer shows field name, and 2nd slicer shows field values which dynamically adjusts based on the field selected in slicer 1. See mockup below. When I click on Region,  before I select anything, my line chart shows 100 lines for all regions. When I click on VP, my line chart shows 100 lines for VPs and so on. Is there any way the second field parameter slicer can only have 1 or two values preselected so my chart doesn't look messy as soon as it's selected?

field parameters.png

So my line chart looks like this before selecting anything. I'd rather have 1 or 2 lines preselected instead of my users seeing this as soon as they select a field in slicer 1.

line chart.png

 

amitchandak
Super User
Super User

@hprose , if you need two slicers for Axis/Measure , then create two field parameters.

 

But if you need two slicer for categorical value like product , you need to take help from independent table

 

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

 

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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