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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors