Forum Discussion

ryan0585's avatar
ryan0585
Advocate II
1 year ago
Solved

Dynamic Formatting with DirectLake Semantic Model

We've created a semantic model using DirectLake mode for the first time. In that semantic model, we're able to create measures that use dynamic formatting of the results. The use case is that we are ...
Need Help
ryan0585's avatar
ryan0585
Advocate II
1 year ago

Yeah so the second bullet there. We'd like to use the switch statement to evaluate the user's metric selection, then return a measure value in the appropriate format. Some sample DAX here we're using in the semantic model for the Format = "Dynamic" selection. Unfortunately, we just can't take this same approach ATM in a local .pbix file connected to that semantic model.

 

 

VAR SelMeasure = SELECTEDVALUE('metric'[metric_id])
RETURN
    SWITCH(
        SelMeasure,
        16, "#,0;-#,0;#,0",
        18, "#,0;-#,0;#,0",
        2, "0.0%;-0.0%;0.0%",
        3, "0.0%;-0.0%;0.0%",
        4, "0.0%;-0.0%;0.0%",
        5, "#,0;-#,0;#,0",
        47, "#,0;-#,0;#,0",
        6, "0.0%;-0.0%;0.0%",
        7, "0.0%;-0.0%;0.0%",
        8, "0.0%;-0.0%;0.0%"
    )