Forum Discussion

ziogis's avatar
ziogis
New Member
7 years ago

Adding two percentage values to visual

Hello,

I'm still new to Power BI and trying to understand how everything works, today I ran into while trying to add two different values% into one visual. 

Both look like in picture above and I need to make trend going day-by-day of both in same visual. When I insert one value everything looks good but when I add second value it becomes sum of all percentages:

Therefore I am struggling to change that both values would be same format and would make a nice trend. 
Sorry for such a basic question but I really lack knowledge yet!

7 Replies

  • Salvador's avatar
    Salvador
    Responsive Resident

    Hello,

     

    Using the line chart, under visualizations, Analytics (by default it shows the fields view), you can add a trend line, so no need of adding new values or calculating the trend :D

     

    Regards,

    Salva.

  • Thim's avatar
    Thim
    Resolver V

    Could you supply a sample data, or show how the visualization and fields are setup? :-)

     

     

    • Salvador's avatar
      Salvador
      Responsive Resident

      Hello Thim,

       

       

       

       

      I hope this solves the issue :D

      Regards,

      Salva.

      • ziogis's avatar
        ziogis
        New Member

        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.