Power BI Dynamic headers

[sailochanar]

Hey Mates ,

I wanted to know how to create dynamic headers for the visual according to slicer selection ,Actually I added the measure in title field according to slicer selection the header is getting changed in visual but the issue it is concatenated with (table name +column name ),that how to avoid the table name.

How to solve it..?

@Arul @amitchandak @JorgePinho

Thanks.

[Madhavarao]

For your reference this solution should work:
Measure = VAR Madhav=SELECTEDVALUE(Sheet1[Facility],"ALL")

Return

CONCATENATE("Emossion by ",Madhav)

[SamiS]

Hi,

Is that dropdown field based on field parameter?

You could try this measure:

dynamic_header = // Show the column name of the selected field parameter
var TextToParse = SELECTEDVALUE(Parameter[Parameter Fields])
var Index = LEN(TextToParse)-SEARCH("[", TextToParse)
return "Value: "& RIGHT(SUBSTITUTE(TextToParse, "]",""), Index-1)