Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gianmarco
Helper IV
Helper IV

Need help with matrix table visualization

Dear All,

I have the following matrix visual in PowerBI:

Cattura.PNG

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:

Cattura1.PNG

 

Thank You a lot

gianmarco

 

1 ACCEPTED SOLUTION
bolfri
Super User
Super User

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 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
bolfri
Super User
Super User

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 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors