Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago
Solved

Text 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),     (...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    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"
    )
    )

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
1 year ago

Your logic is working, as you have something selected, it returns No selection

To avoid this issue, the following approach should solve

 

Placeholder Text =
VAR SelectedValue = SELECTEDVALUE('Seg/BU/Sub BU/Product'[Seg/BU/Sub BU/Product Fields])
RETURN
IF(
ISBLANK(SelectedValue),
"No Selection",
SelectedValue
)