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 everybody,
I want to display a line chart with two different value fields coming from two different tables.
The problem is that only one of the two lines is displayed correctly with every value aligned to the corresponding month. The other one, depending on my selection, is always the sum of the values for every month, or the min of the values for every month, or the max of the values and so on.
It seems that powerBI can't recognize the time split for both of the lines, but only for one.
Do you have a solution? Thank you!
Solved! Go to Solution.
Hi @alecalma,
To what I can understand you want to make a line chart with X-axis of Dates and using different tables, you need to create a dimension table with a calendar and then make a relationship between this one and the other two tables, then use the dimension table on your axis and the values of both tables for your line values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @alecalma,
To what I can understand you want to make a line chart with X-axis of Dates and using different tables, you need to create a dimension table with a calendar and then make a relationship between this one and the other two tables, then use the dimension table on your axis and the values of both tables for your line values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |