Forum Discussion

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper 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
Icon for Helper V rankHelper 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