Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Metric | Actual Value | Metric Format |
A | 0.88 | 0% |
B | 2497 | #,##0 |
C | 435 | $#,##0 |
Output:
Metric | Desired Outcome |
A | 88% |
B | 2,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.
Solved! Go to Solution.
The below code worked:
Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])
The below code worked:
Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |