Forum Discussion

sumachintalapan's avatar
sumachintalapan
Frequent Visitor
2 years ago

Dynamic Formatting based on the slicer selection

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...
Need Help
sumachintalapan's avatar
sumachintalapan
Frequent Visitor
2 years ago

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