Dynamic Axis in Boxplot

[Anonymous]

Does anyone know if it is possible to dynamically change, as with scatterplots, the axis in the MAQ Software Boxplots? If not, any other alternative?

[AmiraBedh]

You add a table or a list with the names of the fields you'd like the user to select as axes.
Then add a slicer to the report and link it to this table or list which will let users choose which field they want to use for the axis.

You will need to create a measure that reads the slicer value and then fetches the relevant column data based on that selection.

DynamicAxisValue =
SWITCH(
SELECTEDVALUE('Axis Table'[Axis Name]),
"Option 1", SUM('Data Table'[Field 1]),
"Option 2", SUM('Data Table'[Field 2]),
...
SUM('Data Table'[Default Field])
)

You can add the `DynamicAxisValue` measure to the appropriate axis on the boxplot. When users select a different option in the slicer, the measure will adjust, and the chart's axis will change accordingly.

[Anonymous]

Thanks for the answer! If I only need the y-axis of the boxplot to change dinamically, would I still use a switch statement?