Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fixed curve on Power BI scatterplot or line graph

I have this Excel graph I want the fixed curve to stay put in a Power BI scatterplot or line graph. I know how to graph the data and I use the slicer tool to change the data, but I want to have this curve fixed in a scatterplot or line graph as the control limit of the data. I also want the curve to stay fixed even when I select another set of data using the slicer tool.

Need Help

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    Without seeing your model, I would think you could do the following:

    • set fixed values for the x and y range in your visual (so they don't change with slicers)
    • create a table that has your x values and put your fixed curve data in one table and your other data in another
    • create a relationship between the x table and each of the other two tables (on the x values columns); use the shared x column in your visual, along with two measures (one for each of the y value columns)
    • add slicers, etc. to filter your other data table (so the fixed curve one is unaffected)

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I would like the curved graph to show on the graph with the batches and stay even though I use a slicer to select a different batch number. 

      Is there a way to merge them or that a scatter plot shows two graphs in the same visual?