Forum Discussion

Janee's avatar
Janee
Frequent Visitor
1 year ago

Feature request: Ability to adjust dynamic title when using field parameters

It's great that titles in visuals can be dynamic based on the field parameters! I use three parameters in my visual y-axis: parameter with sessions, unique visitors, pageviews, interaction events. x-axis: year, month, week. Legend: parameter with per webproducts separated, per webproducts combined, per market group etc. However, the title in the visual shows "...and [field parameter name]". See example below: 

 

But I want it to be like "...like [field parameter name]". When I change that in the visual's title text bar, the title becomes automatically static again and I have to reset the whole title settings. Is there a possibility for us to adjust the static text ("and") in a dynamic title by ourselves? That would be great. 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    Currently, Power BI doesn't allow customizing the static text in dynamic titles when using field parameters. As a workaround, you can create a DAX measure to format the title dynamically (e.g., replacing "and" with "like") or adjust the title text manually, though this resets the dynamic functionality.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you rohit1991 

    Hi, Janee 

    Based on your description, I've created the following example data:

    Again, I have two field parameters:

    Create the following title measure

    Title = 
VAR _x= MAX('X-aixs'[X-aixs])
VAR _measure = MAX('Parameter'[Parameter])
RETURN _measure & " per " &  _x

    Apply it in your charts:

    Here are the results:

     

     

     

    Best Regards

    Jianpeng Li

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