Forum Discussion
Dropdown list slicer placeholder
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 🙂
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.
2 Replies
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.
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.
