Dynamically change X & Y axis on Scatter graph

[Anonymous]

Hello All,

Need your suggestion-

I have a scatter graph with X & Y axis. Say, I have building and vehicle on X & Y axis respectively. Now I need to change those dynamically to theft and robbery. I can create the category for x and y axis values and when user selects 2 combination from slicer then the axises should change accordingly. 

Could you please advise how to achieve this or is they any way to make this happen?

Thanks!

[Anonymous]

Hello 

i am also trying to make the same scatter graph with x and y axis dynamic but select the value from slicer different for x axis and different for y axis and for increase circle size in scatter chart one measure slicer will be different ..

Could you please advise how to achieve this or is they any way to make this happen?

Thanks!

[v-yulgu-msft]

Hi @Anonymous,

Could you please provide more description about your requirement?

How is current scatter chart like? And how should it be changed to after users select a value from slicer? If would be better you can post sample data and screenshot.

Regards,

Yuliana Gu

[Anonymous]

Hello All,

Anyone have any idea about this? Please advise.

Thanks!

[JohnP]

I can feel your frustration ... your problem is basically the same I posted in this thread;

https://community.powerbi.com/t5/Desktop/Scatter-Chart-dynamic-X-and-Y-axis-title/td-p/317425

There are some hacks/workarounds, but they are not really satisfactory. Having the axis titles change depending on the dataset are basic functionality in many other BI tools.

I posted an idea here, but I have a feeling this is not Microsoft's priority:

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

[Anonymous]

Thanks @JohnP

I will go through the pbix file mentioned in Chris Webb's blogs but I am afraid if that could work for me or not. But it will surely give me some workaround idea.

I have voted to the idea.

Thank you again!

[Anonymous]

Hi @v-yulgu-msft

Here is the screenshot now-

As of now both the axis are statis for building and vehicle but need to find to change this dynamically. 

Please advise.

Thanks!

[Anonymous]

Hi @v-yulgu-msft

Sorry for not being clear. I have scatter chart. On x axis I have no of burglary of building and on y burglary of vehicles and vakues shows the crime numbers occured on both categories. Now use want to have the x & y asis dynamic i.e. they can compare the relation between two other crime categories e.g. murder and theft, accident or drunk n drive etc. I am not sure how we could change axises dynamically as it was degned in desktop.

So I am thinking to have combinations of crime catgories in slicer and then dynically show that chart but now sure if this is feasible.

I am striggeling to post screenshot here. Not sure earlier it was easy to attach but now its made hard to post.

Please advise. Thanks!