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.

 

Can you help me ?

 

Thank you.

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

8 Replies

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

    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'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