Dynamic Chart Titles and Axis Titles
We like to change chart or axis titles dynamically, for example in what currency is the chart displayed based on the country selection from slicer. There are more need where titles should change automatically.
having a dax expression for column, axis and chart titles would be a huge win for our customers. The problem is when using a SWITCH statement to change a measure for a chart or table I really need the column header / chart axis to change too. There are work-arounds using cards but you lose then when going in to focus mode
Any update on this ?
I want to create a dynamic title which works with drill down/up and not based on the filters applied. For example : By default it show Monthly Trend and then when we drill down to Quarter ( let say ), it will display Quarterly Trend and so on. This can help me to achieve this requirement
Yannick Pauwels commented
Absolutely in favor for this change.
Not only for Charts, also Tables would benefit from dynamic dates.
It would make maintaining exportable tables a lot more pleasant since the title is being used to name the export file.
This is really a must. More even when the user clicks in More Data, as it would be super useful for them to have more context information about the visual. For instance showing the details of a chart of sales for a specific time period it would be great that this information appear in the title.
This would be a very pleasant and usefull improvement. Today, we can create custom titles with measure, but it's a painfull work, too long and the visual result is not really cool as it's not link (no automatic sizing with visual).
We need an integrated tool to create dynamic title, in options of every graph, so we can customized every visual. It should be something like quick mesure with the possibily to add custom text between part of DAX.
Thanks in advance
This is an absolute must - cannot believe it's not possible in current release. I'm even tempted to resort back to building reports in SSRS.
One of the best things about SSRS is that pretty much EVERYTHING can be set via an expression. This aspect of PBI is really lacking and makes it impossible to produce reports/dashboards that adhere to industry standards in-terms of appropriately labelled visuals.
Using a card based on a measure instead of a title is too much of a hack and falls down if the user zooms in to view the visual full screen. It also can't be used for axis titles.
Please consider this because it is definitely a major issue.
Marco Smulders commented
Strongly want this option to be implemented. I know of a workaround with dynamic card, but would be nice if it would be integrated in all visual.
I am in strong agreement with the comment of mike. The calculated measure added to a card workaround have many collateral effects. I wish many formatting features of a visual could be driven by DAX expressions.
Dynamic titles, which can change based on user selected filters would enhance the developer and user experience. E.g. "Sales Created Today" vs "Sales Created Yesterday" where the last word is changing based on a selected filter. The common workaround of creating a calculated measure, adding it to a card and turning off the proper title causes an issue when viewing the chart on a cell phone. When focusing on the chart the user can see "Untitled" at the top of the page.
I strongly agree with being able to use a measure for the title, so when a filter is changed, the title changes. For example, we use a lot of country reports, the report and chart titles should change as we change the country filter.
Yes! This gets to be very important when you start using URLs for dynamic filtering. The chart titles also need to be able to adapt dynamically. Chris Webb had a nice post on this, I can write the measure, I just dont have a good way to display it within the correct visual. Chris gives a work around but that will not work long term.
Exactly, as Anonymous commeted, the real improvemet would be permitting custom measure as title, so that the designer can have total control on the title, and don't having to fake it with and addiotional card visual.
Mauricio Hidalgo commented
An example I want to display transaction sales with options like: Day, Week, Month, Year. If customer clicks Day the sales should show the information based on last 24 hrs only, if they click Week only last 7 days , Month last 30 days and year should be Month based. It will be nice if we can customize the options
I also would like to say that we should be able to assign measures to titles, and perhaps this is what is meant by "dynamic".