Forum Discussion

sailochanar's avatar
sailochanar
Helper II
3 years ago

Power BI Dynamic headers

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.

Need Help
Show and Tell

2 Replies

  • SamiS's avatar
    SamiS
    Frequent Visitor
    3 years ago

    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)
     
  • Madhavarao's avatar
    Madhavarao
    New Member
    2 years ago
    For your reference this solution should work:
    Measure     = VAR Madhav=SELECTEDVALUE(Sheet1[Facility],"ALL")
    Return
    CONCATENATE("Emossion by ",Madhav)