Forum Discussion

cmenendez's avatar
cmenendez
Regular Visitor
9 years ago
Solved

How can I show 2 axis on a column chart

Hi, I have to make a graph of a common value (number of contracts), and I would like to see the number of contracts per creation date, that's easy, but I would like to show in the same graph the num...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    I'd need some sample data to be certain how to help, but if you had a Calendar table of just dates, then you could use this to calculate how many starting and ending contracts you have by using either a couple of measures or calculated columns.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I think what you may want to do is to have a single Axis but two different values for each date, the number of contracts created and the number of contracts ending. 

cmenendez's avatar
cmenendez
Regular Visitor
9 years ago

I guess then that I would need to create another value to calculate the number of contracts starting and ending based on a time scale...

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

    I'd need some sample data to be certain how to help, but if you had a Calendar table of just dates, then you could use this to calculate how many starting and ending contracts you have by using either a couple of measures or calculated columns.

    • cmenendez's avatar
      cmenendez
      Regular Visitor
      9 years ago

      Great, thanks for the help.

       

      I created a table with monthly incremental and I made a calculation for every month of the active customers, and another calculation with the expired customers.

       

      Maintenancecustomers = CALCULATE([nrCTS],
      Filter(ContractData,ContractData[Contract Start]< Dates[Dates]),FILTER(ContractData,ContractData[Contract End]>Dates[Dates]))

       

      With that, I could create the graph which I was looking for.

      Greg_Deckler I will add your comment as the solution

      Thanks again!