cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnP Frequent Visitor
Frequent Visitor

Scatter Chart: dynamic X and Y axis title

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?

 

scatter.jpg

table.jpg

5 REPLIES 5
stretcharm Senior Member
Senior Member

Re: Scatter Chart: dynamic X and Y axis title

 

@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

 

JohnP Frequent Visitor
Frequent Visitor

Re: Scatter Chart: dynamic X and Y axis title

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

JohnP Frequent Visitor
Frequent Visitor

Re: Scatter Chart: dynamic X and Y axis title

I posted an idea that I think would be very useful ... not only for my challenge, but for many others:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32532082-customize-format-visuali...

stretcharm Senior Member
Senior Member

Re: Scatter Chart: dynamic X and Y axis title

cool. I've voted for it.

saurabhgora Visitor
Visitor

Re: Scatter Chart: dynamic X and Y axis title

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 !
Vola !