Forum Discussion
Adding two percentage values to visual
Thank you for help. Sorry if I wasn't clear enough. I do know how to add trend line, issue is that when I add second value to the visual, like the one in my first screenshot, values do not go by the date but gives me one number - sum of all numbers. So I have one line like in your picture but second value line is just a sum of all daily percentages. Its not the trend line I'm trying to achieve here.
Hello,
Could you give some more detail? Are the values of thoose fields related?
There is two different sheets in excel file who look exactly same as first screen shot, just different numbers. I need to take both sheet numbers and make graph with two lines going categorical axis day-by-day with needed values (99.7% ; 97.5% etc.) to be able to compare them as you can see light line in my second screenshot. But when I add second sheet values to the visual it does not become needed numbers 99.7%, 97.6% etc. but instead SUM of all those percentages as one number like you can see black line in second screenshot. I hope that makes sense? Thank you for your patience
Hello ziogis,
IT's adding all the percentages, most likely, because there is no relationship between tables, so PBI doesnt know how to mix them.
If you have unique dates, on power bi desktop, click under home tab, manage relationships, and establish a 1 to 1 relationship between both tables, using the dates field, that should make it :D
Regards,
Salva.