Skip to Content
Author's profile photo Christina Obry

Adding dynamic text to SAP Lumira stories

With the SAP Lumira 1.22 release you can now create text elements that contain dynamic text and will be updated when the dataset is refreshed, ensuring up-to-date content*. For this blog I am focusing on infographic but this can be applied to text boxes in boards and reports as well.

Looking at the following infographic piece, I have 2 numbers in my text elements, which come right from my data. Note that previously I was able to archive a similar effect by adding numeric charts, but adding  dynamic elements to a text object is easier and more flexible than the numeric chart.


Let’s look how this can be done.

Assume you have added a text box to your infographic. As part of the Text Properties you can see a Dynamic Text button.

dynamic Text1.png

On pressing this button a formula editor appear. In this editor you give the formula a name, select the dataset that you want to use and define your formula. For the first text I like to show all submission to my contest, hence I am only selecting the submission measure from the list and press OK.


The value will be added with a light blue highlighting behind it indicating that it is a dynamic text. This highlighting will not be shown in preview or view mode. You can format this dynamic text just like any other text object.


Now I like to show the number of countries that participated in the contest. I don’t really care about the exact number and want to show only multiple of 10, hence adding a formula as dynamic text.


The exact number of participating countries is 41, but thanks to my formula in the infographic only 40+ is displayed, which is the right level of detail that was intended for this infographic.


If you have any comments, please let me know or submit an idea in IdeaPlace.


*For infographics page refresh on open needs to be set in order for the text to refresh.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      very nice addition!



      Author's profile photo Donatas Budrys
      Donatas Budrys


      Thank you for this short and very useful guide.

      Best regards,


      Author's profile photo Iver van de Zand
      Iver van de Zand

      Love it, very usefull

      Author's profile photo Laura VEGA
      Laura VEGA

      Yes really cool.

      I was wondering why you can oly use measures in the Dynamic text?

      I am currently working on a demo for a customer and trying to display in a text box an attribute of the selected product in my board, but in reality only numeric calculations are allowed. Are there some plans to extend the feature?



      Author's profile photo James Batchelor
      James Batchelor

      I am trying to do this as well.   I want to show what dimension value has a specific measure value..   ie.  Country Name where Max(sales).   Not just display max sales value.

      Its not straight forward if its possible.



      Author's profile photo Former Member
      Former Member


      Please is it possible to add a picture in the formula editor?

      I'm working on a demo and i want to display a picture in the text box, for some value of a measure and an attribute