Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicers

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

 

Need Help
  • evandrocunico's avatar
    evandrocunico
    7 years ago

    Hi Anonymous 

     

    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.

     

1 Reply

  • evandrocunico's avatar
    evandrocunico
    Resolver III
    7 years ago

    Hi Anonymous 

     

    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.