Hello ... I just started learning Power BI and it seems really good so far!
I have a scatter chart as shown below. The axis titles are automatically named from the columns dropped in the Axis X and Axis Y (AxisX and AxisY in this case). However, I have a requirement that the axis should be named after another column in the same table (see also pic below). The content of the name columns could change depending on the dataset/report/filter. So, is it possible to name the axis titles after the name columns in this case? Or are there some other tricks in queries etc?
@cwebb has a post that shows you how to do dynamic titles
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.
Final option would be to use r which has lots of flexibility with charts
Thanks 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).
I posted an idea that I think would be very useful ... not only for my challenge, but for many others:
You can rotate the text now !
I got what you are looking for, Firstly your power bi desktop should have September'18 update.
Secondly, you must 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 !