Forum Discussion
Snagalapur
Helper IV
1 year agoText based on Field parameter selection
Hi All, Please suggest measure to udpate text based on Field parameter selction. EX, below Field Parameter: Seg/BU/Sub BU/Product = { ("Segment", NAMEOF('Table'[pl1_descr]), 0), (...
- 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"
)
)
donsvensen
Skilled Sharer
1 year agoHi
Have a look at this article - Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI
Erik