Forum Discussion
Using Fields Parameter to Create a Measure for Dynamic Title of Visual
Dear fellow users,
I am using a field parameters measure to dynamically change the line chart visual based on different fields/indicators (which are create measures). In the field parameter Dax Measure, I revised the names to make it more detailed, so the names and fields have different spellings. The slicers displays the names all right instread of the original field names.
I can also display a dynamic title that changes with the indicator selected through choosing the parameter indicators column as the title. See screenshot below:
However, the problem arises when I tried to create and use a Dax Measure for the dynamic title that include both the Field Parameter and other concatenated text ("across time"). Here is the Dax Measure for the title I created.
The title displayed this time is not the revised name in the field parameter any more but the original field name "table[field]". See screenshot below:
I would appreciate your advice how to solve this problem.
Thanks.
amitchandak Thanks for your reply and your helpful blog.
I revised the dynamic title measure to use Max function with the field parameter. Now the title works fine.
Indicator Parameter TitleOnly = MAX('Parameter Indicators'[Parameter Indicators])& " across Time"
5 Replies
Thank you for the head start. However, I found that this will always return the last value in the field parameter filter if none is selected. I added the fourth argument in the field parameter syntax and I modified the field selection values a bit using the following:
IF(ISFILTERED(parametername[parameterCat]),CONCATENATEX(DISTINCT(parametername[parameterCat]), parametername[parameterCat], ", "), "All")
This will list all values selected, and return ALL if none is selected.Anonymous , I think switch topn blog can help you
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdfamitchandak Thanks for your reply and your helpful blog.
I revised the dynamic title measure to use Max function with the field parameter. Now the title works fine.
Indicator Parameter TitleOnly = MAX('Parameter Indicators'[Parameter Indicators])& " across Time"This was helpful. Although in most cases I will have a single parameter value selected, it is possible more than one is selected. So I came up with an addition that can work with that case.
if(DISTINCTCOUNT('Analyse By 2'[Analyse By 2 Fields]) = 1, MAX('Analyse By 2'[Analyse By 2]), CONCATENATEX('Analyse By 2', 'Analyse By 2'[Analyse By 2], ", "))It would probably work just using the CONCATENATEX expression, but the whole pattern allows for varying the single and multiple cases further.
