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

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

Reply
Kvadratura
New Member

Default value for parameter, connected with slicer when no value in slicer selected.

In my report I have a slicer 'ViewAs" like this:

Kvadratura_0-1705334344114.png

That field connected in the model with parameter:

MyParameter = {
    ("Manager", NAMEOF('fact'[manager_column]), 0),
    ("Director", NAMEOF('fact'[director_column]), 1)
}
This parameter I use in another slicer: with manager_column/director_column values:
Kvadratura_1-1705334902351.png

When I select 'Manager' in the 'ViewAs' slicer, the 'Column Categories' slicer with the parameter displays values from the manager_column. Conversely, when I choose 'Director' in the first slicer, the second slicer displays values from the director_column.

 

Is it possible for the 'Column Categories' slicer to display manager categories by default, when nothing is selected in the 'ViewAs' slicer?

 

Currently, when no selection is made in the first slicer, I get a combined hierarchy in the 'Column Categories' slicer that includes both manager and director categories.

Kvadratura_2-1705335321647.png

P.S. It is not an option for me with single selection for the 'ViewAs' slicer.

1 ACCEPTED SOLUTION

Thank you for your response! Actually, I have found a way to fix this: I applied a filter to the slicer using the Top N (Top 1) selection of fields order of my parameter. This fixed the hierarchy structure and displayed only the correct categories for each role, along with some default behavior when no value in the other slicer is selected.
Sample file 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi, @Kvadratura 

Based on the data provided I am not able to fulfill your requirement at the moment, you can provide the pbix file with no sensitive information about the issue in question. You can try to fulfill your requirement using BookMark.

vyaningymsft_0-1705394713221.png

 

 

vyaningymsft_1-1705394713223.png

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

 

Hello! Thank you for your response. Here's the link to the sample data file: Sample file

I would like to implement this without bookmarks.

Anonymous
Not applicable

Hi, @Kvadratura 

 

Long time waiting, I tried many ways to fix the behavior of changing the default slicer display, which doesn't seem to be allowed. When dragging the created field parameter to the visual object I find that he displays two columns of data, converting to a slicer will definitely have a hierarchical relationship. If you don't mind, you can try converting the slicer to a new slicer where the last selected visual will be preserved. But the new slicer is a new feature introduced recently, and its visual effect may or may not be too good. If you think the new slicer doesn't meet your needsYou can submit an idea for here and the product team will take note of such a need.

 

Related Link: New tab (powerbi.com)
New button slicer: New button slicer | Public preview | Microsoft Power BI Blog | Microsoft Power BI

vyaningymsft_0-1705653406242.png

vyaningymsft_1-1705653719640.png
Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Thank you for your response! Actually, I have found a way to fix this: I applied a filter to the slicer using the Top N (Top 1) selection of fields order of my parameter. This fixed the hierarchy structure and displayed only the correct categories for each role, along with some default behavior when no value in the other slicer is selected.
Sample file 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

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

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.