Scatter with data from two queries

[ODJAPO]

Hello all,

I have a simle chart to create but I don't know how.

I just want to plot a x,y chart with x and y vector from one querie (sheet) et other x and y vector from another one querie.

Can you help me ?

Thank you.

[v-jiascu-msft]

Hi @ODJAPO,

It seems easy. Can you share a sample please? You can import the two queries into the Power BI Desktop. What's the main problem?

Best Regards,

Dale

[ODJAPO]

Hello @v-jiascu-msft,

Thank you for your answer.

Basicaly, I use a scatter to plot data from the blue querie and I want to add in this scatter the data from the green querie

[v-jiascu-msft]

Hi @ODJAPO,

We can't add them directly. If you can share a sample, that would be great.

1. Maybe we can create a measure.

2. What's the relationships. Maybe we can join two tables as one.

Best Regards,

Dale

[ODJAPO]

Hi @v-jiascu-msft,

I have try to append (concatenate) the two sheets but it don't works because some headers have not the same names.

I have a sample to share with you but for now, I don't know how

[v-jiascu-msft]

Hi @ODJAPO,

You can upload the sample to a cloud drive like OneDrive, GoogleDrive and paste the shared link here if you can make it public. Or send me a private Message.

Best Regards,

Dale

[ODJAPO]

Hi @v-jiascu-msft,

You will find a sample in the link below:

https://drive.google.com/open?id=1yQp7A88BEnDgnm_NrFrfq_UNu9ZzwsZk

Thank you for your help.

[v-jiascu-msft · Accepted solution]

Hi @ODJAPO,

Please check the file here.

Solution 1: If we can change the name of the columns? Then we can append two queries as one. It will be easy after that.

Solution 2: Bring them together into one table.

1. Add an index for each table.

2. Create a new table.

Table =
FILTER (
    UNION (
        ALL (
            EGSDO2_UP_TRAN_LTR[Index],
            'EGSDO2_UP_TRAN_LTR'[msabg_w],
            'EGSDO2_UP_TRAN_LTR'[ResFilLtrB1_I.tiTranRaw]
        ),
        ALL (
            EGSDO2_UP_TRAN_RTL[Index],
            EGSDO2_UP_TRAN_RTL[msabg_w],
            EGSDO2_UP_TRAN_RTL[ResFilRtlB1_I.tiTranRaw]
        )
    ),
    ISBLANK ( [Index] ) = FALSE ()
)

Please pay attention to your privacy.

Best Regards,

Dale

[ODJAPO]

Thank you very much for your answer.