Forum Discussion
Solved
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) ...
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 🙂
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 🙂