Forum Discussion
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...
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
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
Hi v-shex-msft,
it's a great solution, i was strugling to get the column values based on the slicer selection from another table.
thanks for the solution.
Regards,
Swamy