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 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 

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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.

  • sumachintalapan's avatar
    sumachintalapan
    Frequent Visitor
    2 years ago

    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's avatar
    parry2k
    Super User
    2 years ago

    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'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