Forum Discussion

lawada's avatar
lawada
Helper III
4 years ago
Solved

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:

 

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

 

Slicer
Slicer Visualizations
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

    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.

    Display the slicer header.

    Then group them and set the sort display.

    The final show:

    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.

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.

    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.

    Display the slicer header.

    Then group them and set the sort display.

    The final show:

    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.