Forum Discussion
Raki39
Helper I
Helper ISetting 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 ...
truptis
Community Champion
Community ChampionHi 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.