dax works correctly for the card but not in charts (bar,column,pie)

[NILESHSURASKAR]

Final Sell Price =

VAR B = SUM('WIP Data'[Final Sell Price     (Total)])

VAR A = [Final Sell Price USD (Total)]

VAR SelectedAffiliate = SELECTEDVALUE('WIP Data'[PMI Affiliate])

RETURN

IF(

    SelectedAffiliate = "HK" ||

    SelectedAffiliate = "IN" ||

    SelectedAffiliate = "MY" ||

    SelectedAffiliate = "ID" ||

    SelectedAffiliate = "VN" ||

    SelectedAffiliate = "PH",

    MAX('WIP Data'[Currency]) & " " & FORMAT(B, "#,##0"),

    FORMAT(A, "$#,##0")

)

[Anonymous · Accepted solution]

Hi @NILESHSURASKAR 

You can use external tool :Tabular  Editor to format the number

you can refer to the following video to know more about it .

Dynamic NUMBER FORMATTING using CALCULATION GROUPS in Power BI - YouTube

The following link is the website to download the tool.

Tabular Editor 3

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NILESHSURASKAR]

Hello Team,
Thanks for providing the informatiion.

[eliasayyy]

hello @NILESHSURASKAR  it looks like its becasuse you are using the format and strings so in the bar chartsand otehr charts they will be read as text instaed of a number , however you can use this measure in custom data labels

[NILESHSURASKAR]

Hello  Team,
what are the different way of writing the above dax that will be used in charts  and will show the output also 
how to use this measure in custom data labels