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
MFelix's avatar
MFelix
Super User
1 year ago

Hi ryan0585 ,

 

When you refer that you want Dynamic format string does the format that the users are doing should change accordingly to the context for example:

  • Calculation is greater than 1 M then should return  the measure divide by 1M and then add a M to the value
  • Creating a switch measure and then returning the corresponding format also based on a switch calculatio

Or is it just a custom string format for that specific value measure for example they want to add some letters or change the negative to be in parenthisis?

 

According to my test the dynamic format strings are getting the behaviour you refer however I'm able to make any format option written on the format text box:

 



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%"
    )

 

 

    • ryan0585's avatar
      ryan0585
      Advocate II
      1 year ago

      Got it, hopefully this enhancement is added in the future, or "Dynamic" as a formatting option is removed if it isn't to be an enhancement when dynamic formatting is our of preview mode. In its current implementation, when connected to a live semantic model, it does come off as more of a bug because you can select it as a formatting option but the behavior doesn't mirror the functionality of other connection methods. Thank you though.