How to put two different curve on the same graph

[Anonymous]

Hello,

I have table which contains the number of posted invoices per date as well as the total number of invoices processed by date.

If we divide the number of posted invoices by the total number of invoices processed, we obtain what we refer to the Hit rate.

The hit rate is calculated for almost each day for 2019 and 2020.

So I wonder if there is a way to put the two curves on the sames graph, not 2019 and 2020 on the same line.  On for 2019 and one for 2020 but on the same graph.

Does someone know how to do it.

Regards,

[vivran22]

Hello @Anonymous ,

You can do that by creating two measures: one for 2019 & another for 2020

Hit Rate = DIVIDE(SUM(Posted Invoice), SUM(Invoice Processed))

Hit Rate 2019 = CALCULATE ( [Hit Rate], FILTER( tablename, Year = 2019))

Hit Rate 2020 = CALCULATE ( [Hit Rate], FILTER( tablename, Year = 2020))

and then use these measures in your visuals.

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[Anonymous]

Hello,

What you suggest is interesting but What I am looking for is more a dual x axis graph.  Let say that for the first curve, the transaction date vary from jan 2019, fev 2019,..., dec 2019.  For the other curve we have the transaction date vary from jan 2020, fev 2020..., dec 2020. 

So is it possible to get a graph with dual x axis

Regards,

[vivran22 · Accepted solution]

@Anonymous 

In my opinion, following visual should solve the purpose:

This sample visual I have created using measures.

Is this what you are looking for?

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn