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.
Comments
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.
Thanks!
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.
Thanks!
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 :)
/Haron
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.
/Haron
Please sign in to leave a comment.