This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Dynamic text measures work correctly when using non-Fabric Semantic Models, but when switching to a Fabric Semantic Model, the dynamic text box does not recognise measures that utilise a parameter slider. This means that when trying to create narrative-driven dashboards that utilise parameters, dynamic text is unusable.
Example scenario:
Text box: "10 times [x] is [10x]"
Slider range: 1 to 100
Measures:
[x] = Slider_Value
[10x] = VAR Value = SELECTEDVALUE(Slider_Value) RETURN 10 * Value
Expected output: "10 times 17 is 170"
Observed behaviour: The output functions correctly in non-Fabric SM, but in Fabric SM, the dynamic text box fails to allow measure selection.
Here is a real example with dummy data.
The first is a model with dummy Excel-led data.
The second is a model with dummy Fabric Semantic model data.
In both, I can create a KPI card that calculates the value of the measure. However, only in the Excel-led model does the Q&A read the value for dynamic text. This sucks.
1. Excel
Excel Example that works
2. Direct Query/Fabric SM
Fabric Semantic Model that doesn't work
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.