2 VAR in X-Axis: Is it possible to represent both numerical variables matching the values?

[OihaneFernández]

Hi community,

I will really appreciate your suggestions for the next use case.

Scenario Description:

• 4 variables with the purpose of monitorize hysteresis: [Iup - Qup] VS [Idown - Qdown]
• X-axis must be for I
• Y-axis must be for Q
• Currently, the SQL server stores registers per every PLC read (I and Q per time).

Orientation request:

How could I manage two variables in the X-axis?

I would like to use Iup and Idown variables in X-axis but, the objective will be to match up in the X-axis the same values for this two different variables.

Example, analysing the dispersion graph, if i move to X-axis Iup = 2000mA, also I would see Idown = 2000mA because both variables are matching in diagram and they display the same value (then, in Y-axis we will see Qup and Qdown values, different values between each other).

See the attached screenshot for graphical details.

Thank you in advance for the provided orientation.

Oihane.

[v-shex-msft · Accepted solution]

HI @OihaneFernández,

I'd like to suggest you do unpivot columns on these value fields to convert them to attribute and value, then you can use 'value' on axis and 'attribute' to legends to split and group these values.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng