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

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago

thanks BetterCallFrank!

switch i a good solution but i would like to have 5 values for example not only one depending on slicer selection.

example when i select sales from slicer to have in a table my 5 sales columns (phone sales, laptop sales eg)

when i select profit to have my other 5 profit columns...

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi giorgiokatr

     

    Can you share some data and the visual you expect to understand the problem better.  You can do this on onedrive and post the link

     

    Cheers

     

    CheenuSing