modify the slicer filter

lawada — Wed, 11 May 2022 19:53:17 GMT

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 :

Re: modify the slicer filter

amitchandak — Thu, 12 May 2022 06:34:37 GMT

lawada , I doubt there is an option for that

Re: modify the slicer filter

v-yalanwu-msft — Mon, 16 May 2022 07:26:38 GMT

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.

topic modify the slicer filter in DAX Commands and Tips

modify the slicer filter

Re: modify the slicer filter

Re: modify the slicer filter