The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
62 | |
53 | |
51 |