Forum Discussion

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago
Solved

table with dynamic values (columns)

is it possible in a table to have dynamic values depending on a slicer?     Rows will have Branch and values will have different columns each time i select a value from a slicer (eg sales when i...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi giorgiokatr,

     

    Sorry, It seems like I have forgot to paste the measures.

     

    field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3]))
field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))

     

     

    Regards,

    Xiaoxin Sheng

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool,

 

1. We can't change the calculated column value while selecting in slicer.

 

but we can achieve whatever u looking for with the help of Calculated measure. please share your fromula .

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi giorgiokatr,

     

    You can refer to below method to show the dynamic fields value.

     

    Add a index column to current table.(let measure calculate all the rows)

     

     

    Add a measure to slicer's source table to get the selected value.

    Selected = if(HASONEVALUE(selection[Slicer]),VALUES(selection[Slicer]),BLANK())

     

    Create the table visual.

     

    Result:

    Notice: if table not contain the index column, it will only show one value.

     

     

    Regards,

    Xiaoxin Sheng

    • giorgiokatr's avatar
      giorgiokatr
      Helper V
      9 years ago

      thanks Anonymous! what is the dax formula for field1 and field2?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi giorgiokatr,

         

        Sorry, It seems like I have forgot to paste the measures.

         

        field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3]))
field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))

         

         

        Regards,

        Xiaoxin Sheng