ewilliams0405's avatar
ewilliams0405
Frequent Visitor
3 years ago
Status:
Needs Info

BUG: Dynamic Format Thousands (k) w/out decimal displays correctly in data labels

The dynamic format thousands (k) when displayed with a decimal appears correctly in both data labels and tables.  But with no decimal the dynamic format for thousands only appears correctly in table visuals.  The respective values do display in data labels.  The display unit are set to none.   

 

 

Format: 

SWITCH(TRUE(),
SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) < 100000, "$#,##0;($#,##0)"
,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) < 1000000, "$#,0,.K"//"\$#,0,.k;(\$#,0,.k)"
,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) >= 1000000, "\$#,0,,.0M;(\$#,0,,.0M)"
,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) < 100000, "#,##0;(#,##0)"
,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) < 1000000, "\#,0,.k;(\#,0,.k)"
,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) >= 1000000, "\#,0,,.0M;(\#,0,,.0M)"
,"#,0;(#,0)")

 

I believe this is a bug in the dynamic formating as no thousands format appears to work and it only appears to an issue when used in data labels.  

 

It would be nice to turn off the dynamic formating to display the base value for validation purposes or in visuals where the format may not be required.  

Reports

4 Comments

Completed Ideas