Forum Discussion
Dynamic formatting for negative values
Hi bbass82
I think you just need to add one condition within SWITCH to your current expression to handle negative numbers between -1m and zero.
I would write the overall expression like this with SELECTEDMEASURE assigned to a variable:
VAR MeasureValue = SELECTEDMEASURE ( ) VAR Result = SWITCH ( TRUE ( ), MeasureValue < -1e6, "$#,##0,,.0M", MeasureValue < 0, "$#,##0,.0k", -- new condition MeasureValue < 1e3, "$#,##0", MeasureValue < 1e6, "$#,##0,.0k", -- Otherwise >= 1e6 "$#,##0,,.0M" ) RETURN ResultPBIX attached in case that helps debug.
You could consider using conditions based on ABS ( SELECTEDMEASURE () ) if the same format string applies to positive/negative values in the same absolute value range.
Are you able to get it working at your end?
Regards
Owen
Hi bbass82
I think you just need to add one condition within SWITCH to your current expression to handle negative numbers between -1m and zero.
I would write the overall expression like this with SELECTEDMEASURE assigned to a variable:
VAR MeasureValue = SELECTEDMEASURE ( )
VAR Result =
SWITCH (
TRUE ( ),
MeasureValue < -1e6, "$#,##0,,.0M",
MeasureValue < 0, "$#,##0,.0k", -- new condition
MeasureValue < 1e3, "$#,##0",
MeasureValue < 1e6, "$#,##0,.0k",
-- Otherwise >= 1e6
"$#,##0,,.0M"
)
RETURN
Result
PBIX attached in case that helps debug.
You could consider using conditions based on ABS ( SELECTEDMEASURE () ) if the same format string applies to positive/negative values in the same absolute value range.
Are you able to get it working at your end?
Regards
Owen
Hi Owen,
Thank-you so much for this solution. Worked perfectly for what I was trying to show in my pbix. I am still new to the absolute conditions piece and will be studying up as suggested on how to you utilizate absolutes within my dax.