Forum Discussion
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 ...
mahoneypat
Microsoft Employee
Microsoft EmployeeWithout 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
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?