Forum Discussion
Helper IIIDynamic Titles in Power BI
Hello,
I have 50 charts that they need to have dynamic titles.
I created an Excel file with all titles, and the file can be updated by customers any time.
Then I imported all titles to a table ( table1 ) in Power BI.
After that, I created one measure for each title and get value for each title from table1.
The only thing , I do not like this soution, I need to create one measure for each chart.
Is there any better soution?
Thanks
Nicki
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
5 Replies
- edhans
Community Champion
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.
NickiI 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
- Greg_Deckler
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
- Nicki
I apperciate your responses.
Both soutions are good but there is no pattern for my titles and I will go to create a measure for each titles.
Thanks
Nicki
- edhans
Sorry we couldn't be of more help Nicki - but sometimes the solution isn't possible.
Kudos are appreciated for any posts that helped (the thumbs up) but please mark something as the solution so this thread can be marked as solved - even when the solution is "there is no perfect solution. " 🙁