Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Is there guide for syntax for use in Dynamic Values within a Text Box?

Hello everyone - hope you are well.


I've been playing around with the Dynamic Values option within Text Boxes. Recognising that it's based on sentences rather than strict coding rules, is there a guide available about how the AI would interpret different sentences?


An example of the sort of thing I'm looking for is the % of the total in a pie chart showing a split by gender for the biggest gender category.

I've used the following based on copying the structure in a similar return in a Smart Narrative visual, but it gives me a return of female rather than a %??

Count of Client Number for Gender with the highest total of Count of Client Number as a % of total.


If there is an easy to find guide out there that I've just plain missed, apologies in advance 🙂

Frequent Visitor

Thank you for your reply @amitchandak . There is a lot of useful information in the page you sent the link for, but I couldn't really see what I need about a comprehensive list of how the new functionality would interpret different syntax.

Super User
Super User

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors