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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I need some expertise here.

I have imported excel from sharepoint in power bi as dataset.

In power bi desktop i have connected it as live dataset using get data method.

Now the issue is that i want to create the dynamic axis using modelling》parameter》field parameter. But it seems that the parameter is greyedout.

 

Any expert please suggest how can i create dynamic axis [field headers]