Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

ewilliams0405

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

Submitted by on ‎05-17-2023 09:50 AM

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.   

 

ewilliams0405_0-1684342034129.png

 

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.  

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎05-17-2023 01:31 PM

I've posted the same issue maybe an hour before you. You may want to upvote mine, there's better chance someone will look into this.

Dynamic format for measure on column/bar chart - Microsoft Power BI Community

Anonymous
Not applicable
‎05-17-2023 11:53 PM

Hi @ewilliams0405 

What is your Desktop version ? I tried to restore the scenario you mentioned but failed, can you provide your pbix file(remove sensitive info) for reference ?

 

Best Regards,
Community Support Team _ Ailsa Tao

ewilliams0405
Frequent Visitor
‎05-19-2023 09:31 AM

@Anonymous The version I am using is 2.116.1145.0 64-bit (April 2023).  Path for file:  DynamicFormattingIssue.pbix

ewilliams0405
Frequent Visitor
‎05-26-2023 08:04 AM

Were you able to open the file from GitHub?

Idea Statuses