Forum Discussion
Solved
Flip columns values (strings - dimensions/rows (Rows section in matrix)) based on parameter
I want to flip the column values based on parameter selection. For example I have two columns First Name and Last Name. Parameter Values --> First, Last Last, First First, Last Option: Fir...
Add extra rows to your field paramter table and another column to group the rows into
NamesParameter = { ( "FirstName", NAMEOF ( 'Names'[FirstName] ), 0, "First, Last" ), ( "LastName", NAMEOF ( 'Names'[LastName] ), 1, "First, Last" ), ( "FirstName", NAMEOF ( 'Names'[FirstName] ), 3, "Last, First" ), ( "LastName", NAMEOF ( 'Names'[LastName] ), 2, "Last, First" ) }The order column determines their display order.
Add extra rows to your field paramter table and another column to group the rows into
NamesParameter =
{
( "FirstName", NAMEOF ( 'Names'[FirstName] ), 0, "First, Last" ),
( "LastName", NAMEOF ( 'Names'[LastName] ), 1, "First, Last" ),
( "FirstName", NAMEOF ( 'Names'[FirstName] ), 3, "Last, First" ),
( "LastName", NAMEOF ( 'Names'[LastName] ), 2, "Last, First" )
}
The order column determines their display order.
