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.
I am trying to plot a basic line chart, where I can compare 3 lines (volume X Year) . When i plot each line individually, the line plots correctly. However when i plot all three lines on a single plot, the number for 2 of the 3 lines are wrong.
For example, line 1, 2 and 3 each have values from 0-1000, with line 1 generally larger than line 2, and line 2 larger than line 3.
When i plot them all on a single plot, line 1 retains its original values but the values of line 2 and 3 change to a constant 217,930 for all years.
Any help would be appreciated. Sorry i can not include an image.
Hi @byronkelly,
Can you share some more insight on what you are making?
Based on your explanation I'm assuming that you are using information for X-Axis from the same table for line 1 and the other 2 lines are from another table or tables without a relationship to the 1st one.
If this is what is happening the result you are getting is the line 1 correct since it's related with the values on X-Axis, and the other two lines are calculated based on it's total number of data points (count or a sum) for the full table where they.
You are getting a constant since the line chart can't determine the context for line 2 and 3 so it return the full sum of those values.
To overcome this you need to have a relationship between the tables you are using in that way when you use a column on the X-Axis all of the value place in the chart will be related and summarized accordingly.
I know this is a little bit theorical but without any additional information is difficult to give you a better answer.
In attach is a PBIX file with 5 tables:
Believe this is your issue, but if not please tell me more specifications on your data model so I can help you.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |