Forum Discussion
Helper IFlip columns values (strings - dimensions/rows (Rows section in matrix)) based on parameter
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.
Helper IYes, two different columns - Both columns has to be displayed same time on report
Super UserAdd 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.
- ninja18
Thank you,
Just a question, these can be drill up and down along with other columns right?
- danextian
You should be able to but the behaviour might not be what you expect. I don't have any other sample data to test this on.
- ninja18
This is exactly what I need. It works with tabular view in matrix visual drill up / down as well. I have tested it.
Honestly this is the best solution with one parameter. I thought I had to create two field parameter and create ordering table and all. This solution is super lightweight for this requirement. Great !