Dynamic content

The "Dynamic content" options are available for all objects. For Text box objects (prior versions: Layout objects) and Menu items, in captions and subcaptions - for other objects, in Title, Labels and Mouse overs.

Generally, the options are:

    • Members - typically for displaying first / last / all members of the selected dimension according to the filtered data set.
    • Criteria - will show the actual criteria for the selected dimension regardless of the result of the filtered data set.
    • Dimension - a handy way of inserting the name of a dimension. Will dynamically change according to end-user language.
    • Measure - a handy way of inserting the name of a measure. Will dynamically change according to end-user language.
    • System variables - a number of informational, useful and auto generated text strings.

Was this article helpful?
0 out of 0 found this helpful


  • Hello,

    How can I add a measure to a text box? In the Dynamic Content menu I only see Measure Name.

    For example Customer Name - Credit Limit USD. I have a report with a iteration per customer.



  • Hi Frank,

    You cannot add a measure value to a Text box - only the measure name, as you already discovered.

    Potential work arounds: Either you would try to combine a Text box with a KPI object as two overlapping/transparent objects. Or you would try to mix text together with measure values in a KPI object alone. Both has its limitations, though.

    More about advanced label/text editor (for the KPI approach) here: https://community.targit.com/hc/en-us/articles/360016155677-Advanced-Labels

    BR / Ole

  • Hi Ole 

    How do i add dynamic content based on a criteria on a user dimension? 

    I have a dashboard, where the user can filter on a user dimension and i want to show the user dimension in the title of my graph. 


  • Hi Peter,

    I am afraid you cannot do that with user dimensions.

    But it might be a worthy candidate for the feature requests list. Please head over here if you want as a new feature request. https://community.targit.com/hc/en-us/community/topics/7278561562141-Feature-requests-Ideas 

    BR / Ole

  • Hi,

    Thank you for the good explanations. 

    I want to hear if its possible to do if statements in the "Dynamic Content" option? 

    I want to do a dynamic title depending on the selected dimensions and if no dimensions are selected I want it to write something like "Select item to continue"

    Looking forward for your reply :)


  • Hi Haron,

    The functionality you are looking for is covered by 'Required criteria'.

    Please see this article: https://community.targit.com/hc/en-us/articles/360017145098-Required-criteria 

    Being a little creative, you can have one text showing when no dimension member is selected (= the text from the Required criteria setting), and another text showing when one or more dimension members are selected.

    The latter part is the creative part: You will need to use a data object, e.g., a Bar Chart. The data is not important because you are going to hide everything by hiding axis lines and axis labels (see this article: https://community.targit.com/hc/en-us/articles/360017045158-Formatting-graphical-objects ).

    Once these things have been hidden, you can insert the desired dynamic text in the chart's title.

    BR / Ole

  • Hi Ole, 

    Thansk alot for your answer. Looks like this will be a big workaround with alot of "Required Criteria" for each of my "krydstabeller" as I have 3 different dimensions and depending on what the user chooses the text should be different. Currently I have this logic in DAX and I just use this DAX query to give me the "Correct" text/dashboard title depending on the 3 dimensions. I just thought maybe the exact same DAX query with IF statements and switch functions could be translated easily in Targit for the Title of my dashboard. 



Please sign in to leave a comment.