topic Chart Value Label Formatting Based on a Variable in App Development

Chart Value Label Formatting Based on a Variable

AJ2024 — Wed, 28 Aug 2024 14:53:40 GMT

Hello,

I have multiple charts in my app that rely on variables to determine which master measure is displayed. I'm trying to format the value labels differently based on the master measure that is used, or more simply, based on the variable value. Here is an example:

IF(vButton_Summary_Measure = 'Individuals #', [# of Individuals],

IF(vButton_Summary_Measure = 'Deposits $', [$ Total Deposits],

IF(vButton_Summary_Measure = 'Deposits #', [# Total Deposits],

IF(vButton_Summary_Measure = 'Loans $', [$ Total Loans],

IF(vButton_Summary_Measure = 'Loans #', [# Total Loans],

IF(vButton_Summary_Measure = 'Total Accounts $', [$ Total Accounts Balance],

IF(vButton_Summary_Measure = 'Total Accounts #', [# Total Accounts],))))))

In the chart, I want all # variables to have the value labels formatted as #,##0 and all $ variables formatted as $#,##0.

Is this possible?

Thanks,

Re: Chart Value Label Formatting Based on a Variable

brunobertels — Wed, 28 Aug 2024 15:03:49 GMT

not tested but may be like this

If(wildmatch(vButton_Summary_Measure,'#'),

num(

IF(vButton_Summary_Measure = 'Individuals #', [# of Individuals],

IF(vButton_Summary_Measure = 'Deposits $', [$ Total Deposits],

IF(vButton_Summary_Measure = 'Deposits #', [# Total Deposits],

IF(vButton_Summary_Measure = 'Loans $', [$ Total Loans],

IF(vButton_Summary_Measure = 'Loans #', [# Total Loans],

IF(vButton_Summary_Measure = 'Total Accounts $', [$ Total Accounts Balance],

IF(vButton_Summary_Measure = 'Total Accounts #', [# Total Accounts],))))))

,#,##0 ,

num(

IF(vButton_Summary_Measure = 'Individuals #', [# of Individuals],

IF(vButton_Summary_Measure = 'Deposits $', [$ Total Deposits],

IF(vButton_Summary_Measure = 'Deposits #', [# Total Deposits],

IF(vButton_Summary_Measure = 'Loans $', [$ Total Loans],

IF(vButton_Summary_Measure = 'Loans #', [# Total Loans],

IF(vButton_Summary_Measure = 'Total Accounts $', [$ Total Accounts Balance],

IF(vButton_Summary_Measure = 'Total Accounts #', [# Total Accounts],)))))),

$#,##0))

Re: Chart Value Label Formatting Based on a Variable

AJ2024 — Wed, 28 Aug 2024 15:53:11 GMT

Worked like a charm after a few minor tweaks, thank you!

Now if I could only leverage auto formatting to display in thousands, millions, etc... I don't think this is possible though. I could manually do it in the expression, but it needs to be dynamic because the values will range greatly depending on how the end user is filtering.

Here is the final code:

If(wildmatch(vButton_Summary_Measure,'*#'),

num(

IF(vButton_Summary_Measure = 'Individuals #', [# of Individuals],
IF(vButton_Summary_Measure = 'Deposits $', [$ Total Deposits],
IF(vButton_Summary_Measure = 'Deposits #', [# Total Deposits],
IF(vButton_Summary_Measure = 'Loans $', [$ Total Loans],
IF(vButton_Summary_Measure = 'Loans #', [# Total Loans],
IF(vButton_Summary_Measure = 'Total Accounts $', [$ Total Accounts Balance],
IF(vButton_Summary_Measure = 'Total Accounts #', [# Total Accounts],)))))))
,'#,##0') ,
num(
IF(vButton_Summary_Measure = 'Individuals #', [# of Individuals],
IF(vButton_Summary_Measure = 'Deposits $', [$ Total Deposits],
IF(vButton_Summary_Measure = 'Deposits #', [# Total Deposits],
IF(vButton_Summary_Measure = 'Loans $', [$ Total Loans],
IF(vButton_Summary_Measure = 'Loans #', [# Total Loans],
IF(vButton_Summary_Measure = 'Total Accounts $', [$ Total Accounts Balance],
IF(vButton_Summary_Measure = 'Total Accounts #', [# Total Accounts],))))))),
'$#,##0'))

Re: Chart Value Label Formatting Based on a Variable

brunobertels — Wed, 28 Aug 2024 16:14:31 GMT

search in the forum for "Dynamically changing number formats" and adapt the approach for your own mesure

It will of course expand it

regards