Formatting Numbers in Switch Dax to show up in chart

[Anonymous]

Hello All, I have a slicer that switches between dollars and units for a measure. Here is the Dax

Payment Selection = if(ISCROSSFILTERED(MeasureType[Units]),

SWITCH( True(),

VALUES(MeasureType[Units]) = "Count", format([Total Payments],"0,000")

VALUES(MeasureType[Units]) = "Dollars", format([Total Payment$],"$0,000")

BLANK()),[Total Payments])

However If i try to format each meausre it does not show up in chart. Maybe because its a text? 

I want to be able to Show in a chart $0,000 if dollars is selected and whole number if count is selected. Is this possible?

[Anonymous]

Hi @Anonymous ,

Did I answer your question? Please mark my reply as solution, thank you~

[Anonymous]

Hi Unfortunetly it does not work still as it will not show up in a graph like a bar or line chart as it is presented as a string. Any ideas how to fix?

[Anonymous]

Hi @Anonymous ,

According to my understanding, you want to dynamically display the formatted value based on slicer, right?

Here are my data sample:

You could use the following formula:

Total Payments =
FORMAT ( SELECTEDVALUE ( Pay[Payment] ), "0,000" )

Total Payment$ =
FORMAT ( SELECTEDVALUE ( Pay[Payment] ), "$0,000" )

Payment Selection =
SWITCH (
    SELECTEDVALUE ( 'MeasureType'[Units] ),
    "Count", [Total Payments],
    "Dollars", [Total Payment$]
)

My visualization looks like this:

Is the result what you want? If you have any questions, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

[FrankAT]

Hi @Anonymous 

use the external tool tabular editor. Take a look at the following link:

https://www.kasperonbi.com/dynamic-formatstrings-with-calculation-groups/

Regards FrankAT

[Anonymous]

see my update. This wont show up in a  chart still.