Forum Discussion
Can we prefix and postfix the text in dynamic chart title using a measure?
Can we prefix and postfix the text in dynamic chart title using a measure?
I need to use a dynamic text which can change in database. We use the word "Event" some users use meeting or Traning etc
So i need display in charts the headings as "New Event members" or "new event count" or "Event Contributions" etc for different charts, but some use Meeting instead of event or any custom text.
I'm acheiving it but using a new measure for each chart.
Is there any generic way to acheive it or can we prefix or postfix text in conditional formatting ?
8 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523In nutshell we need to change the label clients in below charts with Agents or something which is being put by user in database. the client or agent is not fixed there may be any text.
Second request:Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
It has nothing to do with data. You can use ur own data and use any dynamic Title text
I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.
lbendlin Thanks for your contribution on this thread.
Hi Asmasm ,
Do you want to set a dynamic tile for the chart visual? If yes, you can refer the following links to get it.
Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn
Chris Webb's BI Blog: Dynamic Chart Titles In Power BI
How To Create Dynamic Chart Titles In Power BI
Best Regards
Thanks for reply. I did this but the issue is that i need to prefix and postfix text there.
i have many chart and i'm using "client" term there now im using a seperate measure for each chart title. Is there any way to prefix and postfix text in condtional formatting or any other work around?
Hi Asmasm ,
Could you provide clarity on the conditions necessitating the addition of these prefix or postfix text? It is better if you can give a specific example to explain your requirement. Thank you.
In addition, please create a measure as below and check if it can get your expected result...
Dynamic Title = "Prefix Text " & SELECTEDVALUE('Table'[Client], "Default text") & " Postfix Text"Best Regards
