Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
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.
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.
User | Count |
---|---|
84 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |