Forum Discussion

Raki39's avatar
Raki39
Helper I
4 years ago

Setting default slicer value based on a condition

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 ...
Need Help
truptis's avatar
truptis
Community Champion
4 years ago

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's avatar
Raki39
Helper I
4 years ago

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's avatar
    V-lianl-msft
    Community Support
    4 years ago

    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.