This content has been marked as final. Show 4 replies
Uncheck the "nullable" option for that column in the physical layer and restart presentation services. It should disappear.
I know you already tried below method but it is working for me, could you please cross check.
Can you edit your dashboard prompt prompt and find show option then select SQL Result please modify statement like below.
Go--> Edit your prompt--> Show Option--> Select Choice List Values as --> Select Sql result---> change statement like above.
SELECT "tablename"."columnname" FROM "table" where "tablename"."columnname" is not null
Refer this thread might be helpful for you.
NULL Value in the prompt
For your reply , Can we have All Choices option in Radio Button. I could see its possible in 18.104.22.168.0
No you can't. The whole point of a radio button is that you choose 1 single value only.