Freeze/Disable end user to select/unselect one value in the slicer

[DominoPBI]

Hello,

I need to freeze/lock one the values in the slicer, meaning that it should be always selected and end user cant unselect it, or it shouldnt be unselected when clicked on another values. Example below:

Thank you!

[Anonymous · Accepted solution]

Hi @DominoPBI ,

Unfortunately, this feature is not supported in the current version.  You can post your idea to Ideas .

https://ideas.powerbi.com/ideas/

When more people vote for him, the product group will consider updating the feature in the next release.

Alternatively, you might consider creating a custom visual. 

My suggestion is that you can create a new table with additional option values and create a slicer using the columns in that new table. Place a note below the slicer, such as "* Default selection achieved," and create a measure. Add a visual-level filter for the last measure you created show_hide and display the value only when show_hide = 1. Please refer to it powerbi - Hide item in slicer from end user (Power BI) - Stack Overflow

Slicer Filter disable or enable for users - Microsoft Power BI Community

Best Regards,

Neeko Tang

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

[DominoPBI]

Hi @Anonymous 

Thank you for your feedback. I was trying to use below solution but it really affects refresh performance after selection change in slicer

powerbi - Hide item in slicer from end user (Power BI) - Stack Overflow

I was also thinking to use selected value formula in measures that I use in model but it is too much work to include it in tens of measures

(if selected value in Region column = "ASPAC", then take data from column ASPAC,

if selected value in Region column = "LATAM", then take data from column LATAM, and so on)

Anyway, I will treat show_hide as work around solution and I will think to post it as idea as you suggested

Thanks!