Slicers

[MathanKumar]

Hi,

I have an query about slicer component.

I have to shown 3 fields names in slicer drop down list. If i click any one option, it will prodece that fields value in a table. It is Possible to work on slicer tool.

Thanks,

Mathan

[evandrocunico · Accepted solution]

Hi @MathanKumar 

Insert a table:

dim_cols (idx_col, description)

1 - column a

2 - column b

3 - column c

Use col description on slicer, to choose.

Create a measure: column_sel = min('dm_cols'[idx_col])

Create another measure: column_result = if (isblank(column_sel); field_valuea; switch(true();column_sel=1; field_valuea;column_sel=2; field_valueb;column_sel=3; field_valuec))

Use col column_result on table.

bets regards.