Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did 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

DirectQuery Dynamic Text functionality Improvements - parameterised measures

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 worksExcel Example that works

2. Direct Query/Fabric SM

Fabric Semantic Model that doesn't workFabric Semantic Model that doesn't work

 

Status: New