Forum Discussion
Text based on Field parameter selection
- 1 year ago
Snagalapur , Try using
DAX
PlaceholderText =
VAR selectedValue = SELECTEDVALUE('Seg/BU/Sub BU/Product'[Seg/BU/Sub BU/Product Fields])
RETURN
IF(
ISBLANK(selectedValue),
"No Selection",
SWITCH(
selectedValue,
0, "Segment",
1, "BU",
2, "Sub BU",
3, "Product Grp",
4, "Product",
"Invalid Selection"
)
)
Hello Snagalapur
You can try this
Placeholder Text =
VAR selectedValue = SELECTEDVALUE('Seg/BU/Sub BU/Product'[Seg/BU/Sub BU/Product Fields])
VAR result =
SWITCH(
TRUE(),
selectedValue = "Segment", "Segment Selected",
selectedValue = "BU", "BU Selected",
selectedValue = "Sub BU", "Sub BU Selected",
selectedValue = "Product Grp", "Product Group Selected",
selectedValue = "Product", "Product Selected",
"No Selection"
)
RETURN
result
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- Snagalapur1 year agoHelper IV
thank you for details, I have issue code is returning No selection here.