Question

I need a scatter plot where the x-axis and y-axis dynamically change based on slicer selections—how can I achieve this?
I need to create a scatter plot in Power BI where users can dynamically select the measures for the x-axis and y-axis using slicers. The chart should update automatically based on these selections. What is the best approach using field parameters or DAX to ensure flexibility while maintaining performance?

Answer 1

Create a scatter plot that is going to be dynamic in Power BI, enabling the users to set their x measure through one slicer and then set their y measure through another slicer. Here's what you need to do.

1. Use Field Parameters to Enable Dynamic Axis Selection

In Power BI Desktop, Modeling → New Parameter → Fields.

Select your measures or columns for the x-and y-axes.

Name them X-Axis Selection and Y-Axis Selection.

2. Change the Scatter Plot

Add to the X and Y-Axis fields for the scatter plot the X-Axis Selection and Y-Axis Selection parameters.

Make two slicers so the users can select measures in the report.

3. Performance Optimization

Add pre-aggregation or DAX-efficient computations in Power Query if working with large datasets. Avoid measures that require too many recalculations.