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.
Hi,
I have two tables of 11,246,448 rows and 24 columns. One containing the real values and the other containing the expected values. In order to create an overlaid line chart consisting in both real and expected data I created a query merge but at the moment of closing and applying the load it does not give me any result. I was wondering if it is possible to explain me why this happens. Could it be a license problem? I have the free trial version of Power BI Desktop Premium
Kind regards,
Federica
Solved! Go to Solution.
Hey @Federica_18 ,
can you show us the chart and how you put in the fields?
How do you differentiate between real and expected values? This must be two different values.
You could also have done that with 2 fact tables and the proper dimension tables.
Best regards
Denis
Hey @Federica_18 ,
you could let it as two separate tables and use a date table that you connect with both:
Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic
Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.
For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:
Hey @Federica_18 ,
can you show us the chart and how you put in the fields?
How do you differentiate between real and expected values? This must be two different values.
You could also have done that with 2 fact tables and the proper dimension tables.
Best regards
Denis
Hi @selimovd ,
This is the table containing the real values:
I have columns containing latitude, longitude, date and time of day, temperature, humidity etc. For each coordinate I have measurements made for 31 days at all hours of the day.
The same thing for the table containing the expected values:
Moreover, I thought it could be useful to create a query merge and make a graphs in the following way:
x-axis: date and time of day;
y-axis: measured values (e.g. temperature)
Red line: actual temperature
Blue line: expected temperature
The problem is that when I merge queries, the load fails. Is there another way to make this chart without joining the two tables?
Thank you for your time
Federica
Hey @Federica_18 ,
you could let it as two separate tables and use a date table that you connect with both:
Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic
Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.
For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |