Dynamic Formatting based on the slicer selection

[sumachintalapan]

Hello All, 

I am looking to format my KPI values based on the slicer selection. let say , I have a slicer called "View by" fallowed by Revenue, Margin, "Chargeable Hours"  

and mesure is created like"

viewby=

Var result=

switch(

TRUE(),

'selector view by'[column]="revenue",([Revenue]),

'selector view by'[column]="Margin",([Margin]),

'selector view by'[column]="Chargeable hours",([Chargeable hours]),

)

Return Result, 

now i wanted to dymanically format the each mesures for K (no decimal ),M(3 decimal place) or B (3 decimal Place )  fallowd by $ simbol. for except for Chargeable hours. when user select Chargeable hours the format should be 0decimal values 

[sumachintalapan]

i was able to achive till K format  . but its not giving me M or B format. am not sure where am missing .. 

VAR vformat=

SWITCH(

    'Selector Metric Revenue'[Selected MetricRevenue],

    "Revenue", "£#,#,..K",

    "Margin","£#,#,..K",

    "Chargeable Hours", "#,0.0")

    Var vValue=

    SWITCH(

   'Selector Metric Revenue'[Selected MetricRevenue],

   "Revenue", [NCR_DynamicCheck] ,

    "Margin",[EM_DynamicCheck],

    "Chargeable Hours", [Hours_Dynamic RM])

    var formattedvalue =FORMAT(vformat,vValue)

    return formattedvalue

[parry2k]

@sumachintalapan it is a better approach, either you go with the out-of-the-box functionality and update your visual using field parameters, or just try to create something convoluted, the choice is yours.

[sumachintalapan]

Understood. but the slicer View by is used for other visuals as well. not sure how the filed parameter can mange it other visuals .

[parry2k]

@sumachintalapan I would use a different approach, create 3 seperate measures with the format you want and then use a field parameter for the selection of measure and that will do the job.