Scatterplot - Slicer as the X Axis

[Anonymous]

Hi all, 

I've created 4 different measures, each which calculates a profit based on a revenue scenario.  I've used measures instead of columns (Revenue Column - Cost Column = Profit Column) as the Totals in the table are data points on the graph, and the totals are only correct when I use Measures.  

I'm looking for this to work in conjunction with a Slicer i.e. the Slicer and the X Axis field om the Scatterplot are the same, and as I change the scenario in the slicer, the X-axis adjusts accordingly.  For example, 

Slicer:  Select Profit Measure scenario (I have created a Measure Table with all scenarios)

X - Axis:  Dynamic and adjusts to what Measure scenario is selected

I've looked through a few different queries but they are all slightly different to my query and think I might have to go down a different avenue.

Any help greatly appreciated!

Stephen

Has anyone had experience doing this?

[johncolley]

Hi @Anonymous ,

Sounds like you want to use Field Parameters for your X-Axis: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters 

You can create a slicer of measures and the scatterplot will update the Axis based on your selection.

Please review the provided link and if you require more help or an example please provide some sample data.

If this answer solves your problem please mark it as a solution!

[Anonymous]

Thanks @johncolley for your response.

What-if parameters won't work in this case, as I want to make a calculated column using the result (from what I've read and in my experience, you can't add a measure in a calculated column) which is proving to be the tricky point.

What I am currently looking for is a slicer which chooses the respective column (1,2,3,4 or 5), which is then added to a to provide a result in the last column which I use in my visual.  It's quite convoluted but again any workarounds or input is welcomed.

Cheers, 

Stephen