Skip to main content

Power BI

Needs Votes

Dynamic Chart Titles and Axis Titles

Vote (161) Share
Raghava's profile image

Raghava on 17 Dec 2015 19:53:45

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.

Comments (16)
Raghava's profile image Profile Picture

cbb513d3 b949-48d6-a35d-b5a1d625f0c2 on 05 Jul 2020 23:10:37

RE: Dynamic Chart Titles and Axis Titles

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.

Raghava's profile image Profile Picture

c4439f19 9722-4e45-8a19-dd324f9f5dd4 on 05 Jul 2020 23:01:46

RE: Dynamic Chart Titles and Axis Titles

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.

Raghava's profile image Profile Picture

5701997f 680b-46f5-98ef-ec7efe387116 on 05 Jul 2020 22:54:22

RE: Dynamic Chart Titles and Axis Titles

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.

Please fix.

Raghava's profile image Profile Picture

bff1bf7e 8ad3-40b9-9ece-0297be8f9643 on 05 Jul 2020 22:40:16

RE: Dynamic Chart Titles and Axis Titles

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.

Raghava's profile image Profile Picture

41673707 b38d-4436-bf56-7c2cb102e9d0 on 05 Jul 2020 22:34:42

RE: Dynamic Chart Titles and Axis Titles

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

Raghava's profile image Profile Picture

56a6137e e96a-4f71-9735-e1e8957a373d on 05 Jul 2020 22:30:32

RE: Dynamic Chart Titles and Axis Titles

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".