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

Enhanced scatter 2.0.0 x and y start/end

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. 

1 ACCEPTED SOLUTION
Super User II
Super User II

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:

 

image.png

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:

image.png

 

Hopefully, this provides some ideas to tackle your challenge.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
Frequent Visitor

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.

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.

Super User II
Super User II

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:

 

image.png

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:

image.png

 

Hopefully, this provides some ideas to tackle your challenge.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

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.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors