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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
lawada
Helper III
Helper III

modify the slicer filter

i want to show the slicer title to be inside the bar instead of 'All' in case there is no selection .

how the current slicer look:

lawada_0-1652298787760.png

 

i would  like to have the title to be inside the bar as :

lawada_1-1652298824672.png

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @lawada ;

Currently, we cannot customize the default value of "ALL" to other values such as "All Field Name" in format.

But we can build a visual card by one measure and group this visual and segmenter to achieve its goal.

I build a slicer table.

vyalanwumsft_0-1652685036907.png

Then build a measure.

Measure = 
VAR _countrow =
    COUNTROWS ( 'Table' )
VAR _Total =
    COUNTROWS ( ALL ( 'Table' ) )
RETURN
    IF (
        _countrow = 1,
        MAX ( 'Table'[Year] ),
        IF ( _countrow < _Total, "Multiple Selections", "Year" )
    )

Put measure in card visual and set the text size and display the title.

vyalanwumsft_1-1652685204929.png

Display the slicer header.

vyalanwumsft_2-1652685287836.png

Then group them and set the sort display.

vyalanwumsft_3-1652685444805.pngvyalanwumsft_4-1652685474029.png

The final show:

vyalanwumsft_5-1652685494869.png

vyalanwumsft_7-1652685862479.png

You can vote on an idea using this link for this feature: https://ideas.powerbi.com/ideas/search-ideas/
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @lawada ;

Currently, we cannot customize the default value of "ALL" to other values such as "All Field Name" in format.

But we can build a visual card by one measure and group this visual and segmenter to achieve its goal.

I build a slicer table.

vyalanwumsft_0-1652685036907.png

Then build a measure.

Measure = 
VAR _countrow =
    COUNTROWS ( 'Table' )
VAR _Total =
    COUNTROWS ( ALL ( 'Table' ) )
RETURN
    IF (
        _countrow = 1,
        MAX ( 'Table'[Year] ),
        IF ( _countrow < _Total, "Multiple Selections", "Year" )
    )

Put measure in card visual and set the text size and display the title.

vyalanwumsft_1-1652685204929.png

Display the slicer header.

vyalanwumsft_2-1652685287836.png

Then group them and set the sort display.

vyalanwumsft_3-1652685444805.pngvyalanwumsft_4-1652685474029.png

The final show:

vyalanwumsft_5-1652685494869.png

vyalanwumsft_7-1652685862479.png

You can vote on an idea using this link for this feature: https://ideas.powerbi.com/ideas/search-ideas/
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@lawada , I doubt there is an option for that

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors