Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join now60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more
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.