Forum Discussion
Helper IIIDynamic Titles in Power BI
You need 1 measure per visual if the titles are calculated differently. But if there is a pattern to how it is done, you may be able to script the measures using Tabular Editor. If you are going to do this a lot, then take a look at some of these scripting examples.
If it is a one time thing, or you need to get this published, doing the 50 measures manually will be faster.Nicki - With some fancy DAX you may be able to have less than 1 measure per chart but not enough information to go on. For example, this dynamic title measure demonstrates how you could potentially have a very dynamic title measure that understands the context it is in and returns values accordingly. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/m-p/429587#M154
Community ChampionYou need 1 measure per visual if the titles are calculated differently. But if there is a pattern to how it is done, you may be able to script the measures using Tabular Editor. If you are going to do this a lot, then take a look at some of these scripting examples.
If it is a one time thing, or you need to get this published, doing the 50 measures manually will be faster.
Helper IIII apperciate your response.
It can be a soution if you have a pattern for titles.
There is no pattern for my titles and I am using my soution.
Thanks
Nicki