Enhanced scatter 2.0.0 x and y start/end

[raulallas]

I am trying to use the enhanced scatter 2.0.0 (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380762?tab=Overview) to display some values, but for the sake of visual appeal i need to custom set the start and end of x/y axis. I can't find an option for that under format pane and the closest I've gotten is the data fields X Start, X End ... . However i have tried all the different types of data i could think of in there and nothing seems to have an effect. I have tried searching for documentation and tutortials but have thus far been unsuccessful. 

[Anonymous]

I was frustrated by this and found a fairly easy work-around that worked for me.

1. Go to the original Scatter visualization (not the enhanced)
2. Go to the Format pane
3. Select X Axis
4. Set your Start and End values
5. Select Y Axis
6. Set your Start and End values
7. With your graph selected, apply the Enhanced Scatter visualization

When I did this, it retained the start and end values in the enhanced scatter viz.

I hope that helps.

[Maxi1]

Amazing!! 

Made my day. Incredible that there is no documentation... really hard to learn PowerBI compared to Tableau imo.

Anyways, thanks for the hint. Worked for me as well.

[TomMartens · Accepted solution]

Hey @raulallas ,

as it seems it's only possible to set the start and end of the axis by filtering the values.

For this example I'm using the wide world sample dataset (https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers).

Caution: It's necessary to align the measure that filters the values and the column used in the "Details" band of the visual. The next screenshot shows unfiltered values (numeric column "quantity used" on the x-axis:

where the values on the x-axis in the next screenshot are filtered using this measure:

Total Quantity = 
var xmin = 100
var xmax = 200
return
SUMX(
    'Fact Sale'
    , var __quantity = SUM('Fact Sale'[Quantity])
    return
    IF(AND(__quantity >= xmin , __quantity <= xmax) , __quantity , BLANK())
)

and the screenshot:

Hopefully, this provides some ideas to tackle your challenge.

Regards,

Tom

[raulallas]

Hey, thanks for the tip, I tried using it, but ended up going with blank values at opposite corners of the visual for a cleaner look. However this does answer the question for anyone trying to do it so I will accept it as solution.