Two value in one row in matrix

[Anonymous]

Good morning,
I have a situation like this:

and I'm replicating it as a matrix.
But I was asked if I can change the view to this:

how can i put two values in a field aligned in the center?

or, if I can't do the above, I wish I could replicate a situation like this:

How can I put a space before the field name?

thanks everyone for the help

Best regards

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

KPI:

Then you need to make 'KPI1', 'KPI2', 'KPI3' selected and unpivot them.

There is no relationship between tables. You may create a measure as below.

Result = 
var t = 
ADDCOLUMNS(
    CROSSJOIN(
        DISTINCT('KPI'[New KPI]),
        DISTINCT('Table'[Year])
    ),
    "Result",
    IF(
        [New KPI]="KPI1",
        CONCATENATEX(
            FILTER(
                ALL('Table'),
                [KPI] in {"KPI1","KPI2"}&&
                [Year]=EARLIER('Table'[Year])
            ),
            [Value],
            UNICHAR(10)
        ),
        CONCATENATEX(
            FILTER(
                ALL('Table'),
                [KPI]=EARLIER('KPI'[New KPI])&&
                [Year]=EARLIER('Table'[Year])
            ),
            [Value],
            UNICHAR(10)
        )
    )
)
return
CONCATENATEX(
    t,
    [Result],
    UNICHAR(10)
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

How is the raw data? Is it all in one table? Do you have a Category table that shows that KPI 1 and KPI 2 are part of the same category? If you have this, you could use the stepped layout in matrix to Off, and set Category and KPI as rows. 

For example add a table like: 

Category	KPI
A	KPI 1
A	KPI 2
B	KPI 3

[Anonymous]

@AllisonKennedy thnak for your answer. I have this situatione in my table: