cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ODJAPO Frequent Visitor
Frequent Visitor

Scatter with data from two queries

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Scatter with data from two queries

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 REPLIES 8
Community Support Team
Community Support Team

Re: Scatter with data from two queries

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ODJAPO Frequent Visitor
Frequent Visitor

Re: Scatter with data from two queries

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 Man Happy

 

PowerBI.png

 

 

 

Community Support Team
Community Support Team

Re: Scatter with data from two queries

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ODJAPO Frequent Visitor
Frequent Visitor

Re: Scatter with data from two queries

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 Man Sad

Community Support Team
Community Support Team

Re: Scatter with data from two queries

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ODJAPO Frequent Visitor
Frequent Visitor

Re: Scatter with data from two queries

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.

Community Support Team
Community Support Team

Re: Scatter with data from two queries

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ODJAPO Frequent Visitor
Frequent Visitor

Re: Scatter with data from two queries

Thank you very much for your answer.