Dropdown list slicer placeholder

[ronaldbalza2023]

Hey, beautiful people!

How can I create a dropdown list slicer with a placeholder? For example, I have a column named Client Partner that contains partner names. How can I set up the slicer to display a Client Partner placeholder? Thanks in advance 🙂

[danextian · Accepted solution]

Hi @ronaldbalza2023 

This feature is not currently supported. There are workarounds to make the term 'Client Partner' appear in the slicer, but it is definitely not a placeholder.

Please see the attached sample pbix.

[Ritaf1983]

Hi @ronaldbalza2023 

Unfortunately, this functionality isn't available in Power BI slicers.

There is an existing improvement suggestion regarding slicer limitations where you can add a comment about the placeholder feature or submit your own suggestion. Here’s the link: 

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=67a49092-e950-ef11-b4ac-6045bdb86653

In the meantime, as a workaround, you can add a row to the dimension table used by the slicer with the column name (e.g., Client Partner) and adjust your measures accordingly to achieve the desired functionality.

Measure for example:

Requests QTY =

if (SELECTEDVALUE('Request type'[Request type])= "request type",CALCULATE(COUNT('Table'[ID]),REMOVEFILTERS('Request type')),

COUNT('Table'[ID]))

Result :

Alternatively, you can use the slicer’s title or header to guide users, which is the standard approach.

It is much easier 🙂

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.