Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
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
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
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
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
Thank you very much for your answer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |