Different number format in the same row for a metric

[nbitabc]

We have an aggregate view as a datas source, which is in this format -

This view is used to generate a report in this format in a matrix with Values into row groups -

Is there a way we can get Variance value in percentage value of plan? Something like this -

Appreciate your assistance.

[nbitabc]

Thanks @Gabry. Issue is that Variance is not a separate measure. It is actually an entry in the Key Figure Type column (check the source data screenshot). We can create a new measure for Variance but then we won't be able to maintain the report format as we need Variance as a column header in the matrix

[Gabry]

Understood, can't you create a measure that checks if the variance is inscope?

[Gabry]

Sure, here's an improved version:

Yes, you can achieve that. I believe you can accomplish it using the format panel of the matrix. You should be able to select specific column formatting and then choose 'variance.' If that doesn't work, you can create a measure that checks if the variance is in scope. If it is, the measure returns 1. Then, you can set up a conditional formatting rule based on this measure. If the measure equals 1, apply the red color.