Displaying a Column As dropdown depending upon selecting a value from a table

[Tarunika]

Hi all,

I have a table visual  consisting of Meters_ID column when i select a particular value from the table visuals i want to display the Events as a dropdown depending upon the selection this should happen dynamically.

Please refer the below image i want the last 5 Events dropdown .Can someone help me in achieving this

Meter_ID	Meter Age	Dev code	Event1	Event2	Event3	Event4	Event5
1186804	5173	SA	A	B	C	D	E
1201333	5174	SA	E	D	C	B	A
1207837	5096	SA	A	B	C	D	E
1216660	5182	SA	A	B	C	D	E
1211752	5166		A	B	C	D	E
1206610	4875	PR	A	B	C	D	E
1225577	4901	SA	A	B	C	D	E
1212588	5074	PR	A	B	C	D	E
1221444	4510	PR	A	B	C	D	E
1235894	5434		E	D	C	B	A
1235419	5061	PR	E	D	C	B	A
1258214	4896	SA	E	D	C	B	A
1234494	4922	SA	E	D	C	B	A
1259393	5349	AV	E	D	C	B	A

[Tarunika]

i dont want blank to be seen if nothing is selected. May i know how to remove that

[Tarunika]

Thank You @Anonymous  can we use this in cards 

[Anonymous · Accepted solution]

Hi @Tarunika ,

For display a column as dropdown, you need develop a custom visual to render. Below i provide a sample that use tooltip to achieve your needd without dropdown button.

Please try below steps:

1. create meaure with below dax formula

DC =
VAR cur_id =
    SELECTEDVALUE ( 'Table'[Meter_ID] )
VAR cur_code =
    CALCULATE (
        MAX ( 'Table'[Dev code] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Meter_ID] = cur_id )
    )
RETURN
    IF ( ISBLANK ( cur_code ), "DEV_CODE: NULL", "DEV_CODE: " & cur_code )

Events =
VAR cur_id =
    SELECTEDVALUE ( 'Table'[Meter_ID] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Meter_ID] = cur_id )
VAR _val =
    CONCATENATEX (
        tmp,
        [Event1] & "

" & [Event2] & "

" & [Event3] & "

" & [Event4] & "

" & [Event5],
        
    )
RETURN
    _val

MG =
VAR cur_id =
    SELECTEDVALUE ( 'Table'[Meter_ID] )
VAR cur_age =
    CALCULATE (
        MAX ( 'Table'[Meter Age] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Meter_ID] = cur_id )
    )
RETURN
    IF ( ISBLANK ( cur_age ), "METER_AGE: NULL", "METER_AGE: " & cur_age )

2. configure the report

For more details, please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.