Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ODJAPO
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

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.

View solution in original post

8 REPLIES 8
v-jiascu-msft
Employee
Employee

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.

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

 

 

 

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.

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

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.

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.

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.

Thank you very much for your answer.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.