cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 number of contracts when the maintenance expired:

 

Image 24.png

So at the end my value is the same but the axis would change. Right now I can solve the problem making 2 graphs and just placing one on top of the other...

Is there a way to add both values into the same graph?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: How can I show 2 axis on a column chart

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: How can I show 2 axis on a column chart

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. 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: How can I show 2 axis on a column chart

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...

Highlighted
Super User IV
Super User IV

Re: How can I show 2 axis on a column chart

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Regular Visitor

Re: How can I show 2 axis on a column chart

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!

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors