Search code examples
powerbiscatter-plot

Multivariable Power BI Scatterplot?

My question is similar to this question here:

https://community.powerbi.com/t5/Desktop/Multi-variable-Scatter-Plot/m-p/312013#M138304

I understand that you can only display one variable on the x-axis of a PowerBI scatterplot. But, I'm trying to figure out if there's a way to toggle on/off multiple variables on the scatterplot. For example, the Y-Axis wouldn't change, but you could add/remove different variables to display on the x-axis.

My variables are all in date format, so it would be great to overlay different variables on the x-axis, i.e. "event1", "event2", "event3", so that you could see them in relation to one another. Is this possible? PowerBI has virtually no documentation that I can find.

Solution

  • I'm not sure about multiple variables, but you can at least change the variable to display in the axis based on a slicer.

    The steps:

    1. Create 2 new tables, each representing the possible values on each axis (Just the labels and an index);

    2. Create measures with the values you'll want to see in the axis (ex: Total Sales);

    3. In each table, create a new Measure with a Switch that maps the labels to the created measures.

    Ex:

    Measure Selection I = 
IF(ISCROSSFILTERED('Measure Selection I'[Measure I]);
SWITCH(
    TRUE();
    VALUES('Measure Selection I'[Measure I])  = "Danceability";[Total Danceability];
    VALUES('Measure Selection I'[Measure I])  = "Energy";[Total Energy];    
    );
    Blank())
    1. Create the Visual and the slicers, and put the created measures in the corresponding places.

    Here is a video with an example: https://www.youtube.com/watch?v=gYbGNeYD4OY