Forum Discussion
Displaying a Column As dropdown depending upon selecting a value from a table
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 |
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 _valMG = 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.
3 Replies
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 _valMG = 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.Thank You Anonymous can we use this in cards
i dont want blank to be seen if nothing is selected. May i know how to remove that
