Went down the AI rabbit hole already and got some nonsense out, though it looked promising. What I'm trying to do is have a scatter chart on Power BI and allow the user to input their own X & Y value to place a dot on the chart, so they can compare a quote against our database of actual products. It recommended using Numeric Range Parameters as I understand there is no "input field" to do this. This then required multiple additional tables and measures and then it was a big "whoopsie" when you can't add a secondary Y-axis field. Then of course it says "oh yes that's a limitation of Power BI you can't add a secondary Y axis field" grrrrr... The numeric range parameters sounds alright you know, I just need something where the user can slice the chart to show the product type they want, and then input some numbers or drag a slider to plot their own quote on the chart. Is that possible? Thanks. Table name: DatabaseX axis - Quant 1Y axis - Rate So the user would be inputting their own X axis and Rate via range parameters.

Hii RockandGrohl Use will create two numeric parameters and then use a measure that "injects" those parameters as a new data point into your chart.Step 1: Create the Numeric Range ParametersGo to Modeling > New Parameter > Numeric Range for both your X and Y values:Input X: (e.g., Range 0 to 1000) -> Creates a table Input X and a measure [Input X Value].Input Rate: (e.g., Range 0 to 500) -> Creates a table Input Rate and a measure [Input Rate Value]. Add these as Slicers on your report page.Step 2: Create the "Combined" MeasuresYou need to create X and Y measures that return the database values for your products plus the parameter value for a "Virtual Product."X-Axis Measure:Plot X = IF( SELECTEDVALUE('Database'[Product_ID]) = "USER_INPUT", [Input X Value], MAX('Database'[Quant 1]) ) Y-Axis Measure:Plot Rate = IF( SELECTEDVALUE('Database'[Product_ID]) = "USER_INPUT", [Input Rate Value], MAX('Database'[Rate]) ) Step 3: The "Dummy Row" TrickFor the measures above to work, the chart needs a "row" to attach the user input to.In your Excel/SQL source, add one "Dummy" row to your Database table.Set the Product_ID (or Name) of this row to "Your Quote".Leave the Quant 1 and Rate for this specific row as 0 or Blank.Step 4: Configure the VisualDrag Product_ID to the Values bucket.Drag [Plot X] to the X-Axis bucket.Drag [Plot Rate] to the Y-Axis bucket.Formatting: Go to Markers > Color and use Conditional Formatting. Set the color to Red if the Product_ID is "Your Quote", and Blue for everything else.Why this works:Single Axis: You are only using one Y-axis, but the measure dynamically changes its logic based on which row it is currently plotting.Interactivity: As the user moves the sliders, the "Your Quote" dot will move live across the screen while the database dots remain static.Summary for the CommunityDon't try to add a second Y-axis. Instead, add a Dummy Row to your data and use DAX Measures to swap that row's coordinates with your Numeric Range Parameter values. If this "Virtual Point" strategy allows you to compare your quotes against the database, please mark this as the "Accepted Solution"!

Creative Solution Required - User input fields on a Scatter Chart

Forum Discussion

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Need Creative Solution for P&L Formatting

Slicer requirement

DAX SOLUTION NEEDED

Business Requirement Document Template