Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 M...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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"

     

     
     
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    kleigh
    Responsive Resident
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Thanks for the response. This is even better.