Forum Discussion

cladeira's avatar
cladeira
Regular Visitor
8 years ago

Line Chart doesn't work if you need a legend with multiples measures on values


Simple question: in Excel, I can plot on the same Graph a price average and sales quantity. Line Chart can not do the same thing, am I correct? Which visualization object do i need to use?

Tips and Tricks

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    If you place two or more measures or values in your "Values" area, it automatically creates a legend that allows you to distinguish the multiple lines. If this is not what you are asking, please clarify.

    • cladeira's avatar
      cladeira
      Regular Visitor
      8 years ago

      Hi Greg_Deckler,

       

      Let me give show this example. On the same Line Graph, I want to show the sales and price per day. Unfortunately, none of these fields are related to the "Legend". They're actual values.

       

      Hope it makes sense now. I think "Dual KPI" Custom Visual.

       

       

      Thanks,

      claudio

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        8 years ago

        I still think the solution I mentioned meets your need. See image. I am at a loss as to how this does not fit the requirement.