Need help with matrix table visualization

[gianmarco]

Dear All,

I have the following matrix visual in PowerBI:

In this matrix:

ROWS: I have none

COLUMNS: I have one (DimDate)

VALUES: I have multiple (all these are measures appearing in rows)

What I want to achieve is doubling the measures to have both absolute and relative values (related to column date total), as follows:

Thank You a lot

gianmarco

[bolfri · Accepted solution]

Simply create a dummy table with 2 rows: ABS VALUE, % VALUE and put it in your matrix on columns (below dates). Then in your measure use SWITCH or IF function to show ABS Value or % Value depending on SELECTEDVALUE from this new table. Its simple 🙂