Using Fields Parameter to Create a Measure for Dynamic Title of Visual

[LijunChen]

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. 

Indicator Parameter TitleOnly = SELECTEDVALUE('Parameter Indicators'[Parameter Indicators Fields],"None Selected") & " across Time"

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. 

[dnzdvd]

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.

[amitchandak]

@LijunChen , 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-517aacc23fdf

[LijunChen · Accepted solution]

@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"

[kleigh]

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.

[LijunChen]

Thanks for the response. This is even better.