Forum Discussion

User232431's avatar
User232431
Helper III
1 year ago

Display dynamic selected value if value is missing

Hi , i am trying to show filtered text if it is missing. In above example if i select "USA" then i can able display concatination of "City" and "Value" if i select "UK" how can i display "Cit...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi All,
Firstly  grazitti_sapna thank you for your solution!
And User232431 , I think the situation you need is when selecting UK it is (blank) + value right, here is what I did hope it helps!

Cards_Val = 
IF(
    ISBLANK(SELECTEDVALUE(Sheet[Value])),
    SELECTEDVALUE(Sheet[City]) & " : (Blank)",
    IF(
        SELECTEDVALUE(Sheet[City])=BLANK(),
        "(Blank)" &":"& SELECTEDVALUE(Sheet[Value]),
        SELECTEDVALUE(Sheet[City]) & " : " & SELECTEDVALUE(Sheet[Value])
    )
)

 

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.