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"

     

     
     
kleigh's avatar
kleigh
Icon for Responsive Resident rankResponsive Resident
2 years 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
2 years ago

Thanks for the response. This is even better.