Keep category area's height constant in a chart

[Anonymous]

Hello,

I am creating a scatter chart.

I have Product names on X, and their Total sales on Y.

I am using a scatter chart but not a column chart as I would like to see the sales as just points, not columns. 

I have Y-axis constant lines dividing the Y into ranges, and some images in the background indicating extra info for those ranges

I also have a filter on Product name on the page.

When I have all the products selected, the product names are arranged vertically on X, and the Y axis has some height. When I have fewer products selected, the Product names start to lay horisontally, and the Y-axis height changes. As a result, the position of the Y-axis constant lines change as well, and my extra images do not fit into the right interval, since they stay in the constant position.

Is there any way to deal with it? I would like to either have the X-axis names keep their height, or link the images to the Y-axis constant lines. Any advice is much appreciated!

[amitchandak · Accepted solution]

@Anonymous , I doubt that is auto , means system will choose based on data.

[Anonymous]

Thank you for answering!

On my data it shifts the axis to the degree I cannot use the images. I believe it depends on how big is the product names. That's why I was wondering if it's possible to either keep X names vertically, or do anything else to resolve the issue..

[amitchandak]

@Anonymous , I tried on my system , It do shift the axis. But not by much. Seems like default behaviour ?

Are you getting something really different ?

[Anonymous]

Thanks for answering. Here are the images:

[amitchandak]

@Anonymous , can you share the screenshots of the problem, along with what you have used on x-axis y-axis(in image).

It should work like this with the product on x-axis - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter