Forum Discussion
Need help with matrix table visualization
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
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 🙂
1 Reply
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 🙂