Need dataset with multiple subdivisions filtered down to limited half-integer range before charting

Please see below for dataset and desirable visual.

I just need some guidance/path in constructing a data model and subsequent visuals for the following dataset.

I have various Vessel Names, divided into Test Dates, divided into Operating Mode, then Side of Vessel, then Handle Position, Nominal Speed, Plane of Measurement, then finally, Order (of vibration frequency).

From each of these subdivisions of [Vessel->.....->[Plane], I need to round [Orders] to nearest half-integers (x.5), then filter down to only those Orders that are nearest to each {0.5, 1.5, 2.0, 2.5, 3.0}.

The resulting half-integers between 0.5 and 3.0 will be my Chart Series (in excel terms) plotted on a [Velocity] vs [Nominal Speed] scatter/line chart.

• Should I construct a different Table Expression for each filtered set? (Axial Plane of 950 rpm Nominal Speed of Port Side of James Vessel)

• ....Then allocate every one of those sets to the "Values" of a chart?

I don't really know where to begin.

Excel ScatterPlot to Replicate

I may just go in blindly and try to construct separate CALCULATETABLE(FILTER(ALL measures for each division of [Vessel] down to its [Plane]s. Then try to drop these into a Line/Scatterplot's Values.

I'm hoping I understood your need. Try the following.

Create the following Calculated Columns in order:

Order Group = 
  var mr = MROUND([Order], .5)
  RETURN IF(0.5 <= mr && mr <= 3, mr)


Order diff =
  IF( NOT ISBLANK([Order Group]), ABS([Order Group] - [Order]) )


Order Chart = 
  var gpSubset = [Vessel] & [Date] & [Mode] & [Side] & [Handle Position] & [Nominal Speed, rpm] & [Plane] & [Order Group]
  var gpFilter = FILTER(ALL('Data'), (gpSubset = [Vessel] & [Date] & [Mode] & [Side] & [Handle Position] & [Nominal Speed, rpm] & [Plane] & [Order Group]) && NOT ISBLANK([Order Group]) )
  var minDiff = CALCULATE(MINX(gpFilter, [Order diff]))
  RETURN IF([Order diff] = minDiff, [Order Group])

See if this gives you what you are after.