Forum Discussion
Advocate IIScatter Chart: dynamic X and Y axis title
Memorable Member
cwebb has a post that shows you how to do dynamic titles
https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/
So you could do the X and a horizontal Y text. You cannot rotate the test though.
You could also try using Bookmarks and Selection visability if there are only a few options and select one with an image toggle.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
https://www.youtube.com/watch?v=_Afcj8mT5_Q
https://databear.com/power-bi-bookmarks/
Final option would be to use r which has lots of flexibility with charts
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
Advocate IIThanks for your input stretcharm ... it's hard to understand why the axis title is hardcoded to the name of value column. The only option available is to override it in a textbox in the format tab.
This really seems like a simple feature to implement by entering a formula instead of a just text in the format tab. Many other BI solutions have this as a basic feature. Not only dynamic titles - also about min/max values of the axis, color etc.
The R charts are not really an option since you cannot interact with them like native visualizations. Also in the simple test I did I couldn't get them to respond to slicer choices (the native ones did). The other options are just "hacks", IMO, and is not worth the time and effort (especially since there is no rotate text).
- JohnP
I posted an idea that I think would be very useful ... not only for my challenge, but for many others:
- stretcharm
cool. I've voted for it.
Hi,
It's very simple. Please import "Text Enhancer by MAQ Software" visualization from marketplace.
Once, you are through with the second step, place your dynamic measure under field category, then go to its text settings and change it's direction to vertical !If it helps, like the post. 🙂
Yes, this is a good solution. However, it is effectively layering another visual on top of your chart. This solution will not work if you have (for example) small multiples enabled. Because you'd need the y-axis title to scroll with the multiples.
