Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
Could you please help me to format percentatge and whole numbers in the same matrix? I want the matrix to show % as percentage and numbers as whole number.
Below is a an example table.
Company | Metric | 1H18 | 2H19 |
A | Cash earnings | 1,200 | 2,208 |
A | Net Interest Income | 5,000 | 6,225 |
A | Total Operating Expenses | - 2,554 | - 2,518 |
A | Net Interest Margin % | -2.0% | -3.0% |
C | Cash earnings | 121 | 269 |
C | Net Interest Income | 321 | 520 |
C | Total Operating Expenses | - 621 | - 369 |
C | Net Interest Margin % | -2.9% | 3.5% |
E | Cash earnings | 1,251 | 2,968 |
E | Net Interest Income | 7,215 | 6,213 |
E | Total Operating Expenses | - 4,215 | - 4,578 |
E | Net Interest Margin % | -5.0% | -6.0% |
Thanks in advance.
Regards,
M
Solved! Go to Solution.
@HagenHawke , You can use format function
Switch(Max(Table[Metric]) ,
"Net Interest Margin %", format([1H18], "percent") ,
"Total Operating Expenses", format([1H18], "#,###") ,
//add other
format([1H18], "#,###")
)
refer
https://radacad.com/dynamically-change-the-format-of-values-in-power-bi
@HagenHawke , You can use format function
Switch(Max(Table[Metric]) ,
"Net Interest Margin %", format([1H18], "percent") ,
"Total Operating Expenses", format([1H18], "#,###") ,
//add other
format([1H18], "#,###")
)
refer
https://radacad.com/dynamically-change-the-format-of-values-in-power-bi
Thank you so much. It works.
Kind regards,
M
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |