Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Thanks!
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?
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.
@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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |