Forum Discussion

ODJAPO's avatar
ODJAPO
Frequent Visitor
8 years ago
Solved

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.  ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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's avatar
ODJAPO
Frequent Visitor
8 years ago

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 :manhappy:

 

 

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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's avatar
    ODJAPO
    Frequent Visitor
    8 years ago

    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 :mansad: