I know it's 3 years later, but I think using the terms "source data weight" and "reporting data weight" may help the concepts sink in faster for a subset of users/learners. However, I am not sure that doing so makes the concept less clear to a different subset of users/learners. 😊
Hi Alberto and thank you for sharing with us. I use this approach on my model BUT by doing so, I fall back on direct query rather than DAX query. Is conditional formatting aggregation compliant? All my values and units are in my aggregated table and in my fact table. Any advice?
Hello Alberto! There is a problem that I am facing, the code for "Apply Format String" causing the Category to disappear if you don't expand that category in the Matrix. I've tried solving it but alas it doesn't make any sense, any suggestion? Btw the video is superb Thank you😀
Is there a way to user format string expression for regular dax measures (not calculation groups)? I have a unique case where I can't use calculation groups because I need the end user to be able to use implicit measures when using "Personalize visuals". But when you create calculation groups it removes the option to do implicit measures. Ultimately what I am trying to do is show a label on a bar chart that is different from the value that is creating the bar chart. For example, the value is 10% but I want the label to show "10 / 100". I don't want them to have to hover over each bar to see the tool tip.
Hi Alberto, I would like to report a problem that I am struggling to solve. I am using a calculation group to format a value depending on a slicer that changes the evaluated measure. I have Sales Amt, Margin and Quantity. No problem by using the calculation group method but I have a strange behavior with the waterfall diagram that looses any kind of formatting input as soon as I import any calculation group with a Format String Expression into my model. Do you know anything about that issue and how to solve it ? Thank you very much
Not all of the visuals in Power BI support dynamic format strings yet. I suggest you open a support ticket with Microsoft so they could raise the priority for that visual.
Thank you Alberto, as usual an outstanding explanation! I've tried to reapply the same concept to dynamically format sale with either Mln, k or nothing, depending how big is the output of the selected measure. I'm reporting the Format String Expression at the bottom for clarity. But doing such a thing deteriorates the FE of about 6 times: is it expected ? I've tried different variation of the below and it looks like that what causes the drop in performance is using SELECTEDMEASURE() in the Format String Expression, is this is a known fact? thank you in any case, the video is so insightful in any case. VAR val = SELECTEDMEASURE () RETURN SWITCH ( TRUE, val > 10000000, "#,###,,.Mln", val > 1000000, "#,###,,.0Mln", val > 10000, "#,###,.k", val > 1000, "#,###,.0k", val > 100, "#,###", "#,###.0" )
The format string is probably evaluated for a larger number of cells than those actually displayed. The presence of a custom format string also increases the volume of the result set. We could say this is expected, but the relative cost probably depends on the model, too.
Thank you Alberto for share your knowledge !!! Amazing content as always.
I know it's 3 years later, but I think using the terms "source data weight" and "reporting data weight" may help the concepts sink in faster for a subset of users/learners. However, I am not sure that doing so makes the concept less clear to a different subset of users/learners. 😊
Hi Alberto and thank you for sharing with us. I use this approach on my model BUT by doing so, I fall back on direct query rather than DAX query. Is conditional formatting aggregation compliant? All my values and units are in my aggregated table and in my fact table. Any advice?
Hello Alberto! There is a problem that I am facing, the code for "Apply Format String" causing the Category to disappear if you don't expand that category in the Matrix. I've tried solving it but alas it doesn't make any sense, any suggestion? Btw the video is superb Thank you😀
Link to article - www.sqlbi.com/articles/dynamic-format-strings-with-calculation-groups/
Does it work with #Colors, it added the string itself for them not the color
Is there a way to user format string expression for regular dax measures (not calculation groups)? I have a unique case where I can't use calculation groups because I need the end user to be able to use implicit measures when using "Personalize visuals". But when you create calculation groups it removes the option to do implicit measures. Ultimately what I am trying to do is show a label on a bar chart that is different from the value that is creating the bar chart. For example, the value is 10% but I want the label to show "10 / 100". I don't want them to have to hover over each bar to see the tool tip.
Not yet.
Hi Alberto,
I would like to report a problem that I am struggling to solve. I am using a calculation group to format a value depending on a slicer that changes the evaluated measure. I have Sales Amt, Margin and Quantity. No problem by using the calculation group method but I have a strange behavior with the waterfall diagram that looses any kind of formatting input as soon as I import any calculation group with a Format String Expression into my model. Do you know anything about that issue and how to solve it ? Thank you very much
Not all of the visuals in Power BI support dynamic format strings yet. I suggest you open a support ticket with Microsoft so they could raise the priority for that visual.
Thank you Alberto, as usual an outstanding explanation!
I've tried to reapply the same concept to dynamically format sale with either Mln, k or nothing, depending how big is the output of the selected measure. I'm reporting the Format String Expression at the bottom for clarity.
But doing such a thing deteriorates the FE of about 6 times: is it expected ?
I've tried different variation of the below and it looks like that what causes the drop in performance is using SELECTEDMEASURE() in the Format String Expression, is this is a known fact?
thank you in any case, the video is so insightful in any case.
VAR val =
SELECTEDMEASURE ()
RETURN
SWITCH (
TRUE,
val > 10000000, "#,###,,.Mln",
val > 1000000, "#,###,,.0Mln",
val > 10000, "#,###,.k",
val > 1000, "#,###,.0k",
val > 100, "#,###",
"#,###.0"
)
The format string is probably evaluated for a larger number of cells than those actually displayed. The presence of a custom format string also increases the volume of the result set. We could say this is expected, but the relative cost probably depends on the model, too.
Ciao Alberto, could you please make a video about data lineage to clarify idea to have no data lineage or the very same to link table together?
Thanks for the suggestion - in the meantime, we have this article: www.sqlbi.com/articles/understanding-data-lineage-in-dax/