Forum Discussion
Adding two percentage values to visual
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.