Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, PBI community!
I have two tables:
With these, I can make two separate graphs that you can see below
However, I'd like the two lines superimposed on the same graph. When I try to combine the two into the same graph, as shown in the below picture, I can only seem to get the second line as a constant (either the sum, avg, etc of all the values) as opposed to plotted against the x-axis.
Any suggestions?
Thanks!
Solved! Go to Solution.
Hi @AbbasAsaria90,
The problem here is that you are placing in the axis the week from one of the tables and getting the line of that table since on the second table there is no data for the week column you are refering you don't have a line.
When you add both weeks on the axis what you are making is an hierarchy and not a single axis.
You need to make a relationsoship between the two table by the week column or create a table with the weeks and then relate the two tables to that one.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @AbbasAsaria90,
The problem here is that you are placing in the axis the week from one of the tables and getting the line of that table since on the second table there is no data for the week column you are refering you don't have a line.
When you add both weeks on the axis what you are making is an hierarchy and not a single axis.
You need to make a relationsoship between the two table by the week column or create a table with the weeks and then relate the two tables to that one.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPerfect! I made a date table and related both to that
Thanks
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |