Box plots for 2 different measures

Question

I have a table which looks something like this:

Entity	Month	Relative_value	New_Value
Ball	January	88	90
Ball	February	66	89
Ball	March	55	88
Ball	April	43	81
Ball	May	45	90
Ball	June	65	67
Ball	July	45	45
Ball	August	34	34
Ball	September	29	87
Ball	October	78	12
Ball	November	78	32
Ball	December	54	38

I want to create a visual using the above data showing the box plots for Relative_value and New_value on the same scale. How do I do it, I have tried using the Box and Whiskers chart but it does not allow to have 2 values that can be used nor does Box and Whiskers by MAQ software. Please let me know if there is something wrong that I am trying to achieve or if this is possible.

The final visual should have 2 box plots taking values from Relative_value and New_value columns. How can they have a common y-axis?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Please try below steps:
1. create a new table with below dax formula
CombinedTable =
UNION (
    SELECTCOLUMNS (
        'Table',
        "Entity", 'Table'[Entity],
        "Month", 'Table'[Month],
        "MeasureType", "Relative_value",
        "Value", 'Table'[Relative_value]
    ),
    SELECTCOLUMNS (
        'Table',
        "Entity", 'Table'[Entity],
        "Month", 'Table'[Month],
        "MeasureType", "New_Value",
        "Value", 'Table'[New_Value]
    )
)

&nbsp;
2. visualize the data

Please refer the attached .pbix file.
&nbsp;
Best regards,Community Support Team_Binbin YuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Box plots for 2 different measures

1 Reply

Related content

Cumulative Difference from Another measure

problem while plotting Scatter plot

Different schema into different destination

Toggle between different measures

Waterfall with different measures and different colours