Forum Discussion

Krzysztof_Hyla's avatar
Krzysztof_Hyla
Helper II
5 years ago
Solved

Column Name in Chart Title

Hi I need to build a 2-part measure that I want to use as a chart title.  I'm having problem with the second part b) so any help is much appreciated.   My title measure is a concatenation of two p...
Need Help
veenashenolikar's avatar
veenashenolikar
Helper V
5 years ago

Hi Krzysztof_Hyla 

 

You could try using the function button in the Title setting of the chart as below and then use the same measure in in a) you have mentioned above to create a title that varies dynamically.

 

ChartTitle = SELECTEDVALUE('Warranty Measures'[Measure]) & "by Model #"

 

 

If this helps solves your issue, please mark my reply as a solution

Regards,

Veena Shenolikar

 

  • Krzysztof_Hyla's avatar
    Krzysztof_Hyla
    Helper II
    5 years ago

    Yes, but the thing is I don't want to hard-code "by Model #" in the formula.

    I would like for the let's call it [MEASURE_B] to take value from the name of the column "Model"

    So that it will change dynamically when I apply this title formula for another chart.

     

    ChartTitle = SELECTEDVALUE('Warranty Measures'[Measure]) & "by " & [MEASURE_B]"