How to create control with column names as a dropdown with datatype as decimal in the dataset

How to create control with column names as a dropdown with datatype as decimal in the dataset

Please follow the below steps to achieve the use case to create control with column names as a dropdown with datatype as decimal in the dataset:

Please refer the below dataset and its datatype before moving to steps

Steps:

  1. Create a parameter named as “columnnames” check the screenshot (parameter) with static value as “10/01/24 0:00”

  2. Created a calculated field with the formula;

ifelse(${columnnames}= '10/01/24 0:00',{1/10/24 0:00},${columnnames}= '11/01/24 0:00',{1/11/24 0:00},${columnnames}= '12/01/24 0:00',{1/12/24 0:00},${columnnames}= '13/01/24 0:00',{1/13/24 0:00},NULL)

Here columnnames is the parameter name

  1. Created a control named as “cn” please find the screenshoot(control) with specific values as name of the columns

  2. Created a visual with calculated field as a column as shown in screenshoot (visual)

Attaching screenshots for parameter, controls and visual