Setting default slicer value based on a condition

[Raki39]

Hi All,

Is there any way to set the default value based on the condition?

EX: I have a number column and a flag. Here I need to have a slicer with number columns and the default selection would be based on the flag where the flag value=Y then that related number value has to be selected by default.

Thanks in advance,

Rakesh

[truptis]

Hi @Raki39 ,

Try creating a new field in Power Query using this:
if Flag = "Y" then "defaultvalue" else "value"

In place of defaultvalue and value, you can put a column name else the default value that you need.

@Raki39 -> If this helps you then please mark it as a solution and hit the thumbs up. Thank you.

[Raki39]

Hi @truptis  Thank you for the response. Here In my case, I dont have the previlage to create new column as the connection is a live connection. is there any way that I can do it writing a measure?
So sorry I missed to mention it.

[V-lianl-msft]

Hi @Raki39 ,

As per my knowledge, this feature is not supported yet in Power BI slicer.

You can use bookmarks to set a stand default filter button, and another as clear all filters

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