dynamic subtitle for all measures without table name?

Hi Anonymous 

 You're getting a result that includes the table name because you're referencing the actual parameter field column – which contains the full field name including the table. This column is meant to act as a binding reference, not something intended for display.

However, there's also a limitation: you can't directly return the parameter field's name without the table prefix.

The common workaround is to add another column in the parameter table that stores a display-friendly label (e.g., just the measure name), and use that column for your dynamic title.

That’s what I did in my setup (see screenshots). I created an extra column (e.g., [category parametr]) that holds the readable names, and used that in the CONCATENATEX for the subtitle, instead of the parameter field column itself.

For example To get matrix as mine :

At the first step add the column to parametrs table:

 

Then use it in the wanted DAX, like :

Title for parametrs = CONCATENATEX(VALUES('Categories for comparison'[category parametr]),'Categories for comparison'[category parametr],">>") & " sales analysis"

 

Note:
The order of measures shown in the subtitle follows the sort order defined in the parameter table, which doesn't necessarily reflect the user's selection order 

The pbix with the example is attached

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly