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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rohini
Helper I
Helper I

Custom Format each row based on column

I have data in the below format with the columns 'Metric', 'Actual Value' and 'Metric Format'. Based on the column 'Metric Format', I would like to populate the column 'Desired Outcome' in the visual (matrix) in the output.

Input:

MetricActual ValueMetric Format
A0.880%
B2497#,##0
C435$#,##0

 

Output:

MetricDesired Outcome
A88%
B2,497
C$435

An ex-employee was able to do this and I am trying to figure out where the settings need to change. Would appreciate if anyone can help.

 

1 ACCEPTED SOLUTION
Rohini
Helper I
Helper I

The below code worked:

 

Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])

View solution in original post

2 REPLIES 2
Rohini
Helper I
Helper I

The below code worked:

 

Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])

goncalogeraldes
Super User
Super User

Hello there @Rohini ! Check if this works for you:

Desired Outcome =
VAR _current_row =
    SELECTEDVALUE ( 'Your Table'[Actual Value] )
RETURN
    SWITCH (
        _current_row,
        "0%", FORMAT ( _current_row, "Percent" ),
        "#,##0", FORMAT ( _current_row, "#,0" ),
        "#,##0", FORMAT ( _current_row, "$#,0" )
    )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.