*URGENT* - Dual axis chart

if the value would still the same then you shouldn't be using a secondary y-axis

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

The objective is to replicate the chart in excel. If I create a duplicate measure, I'm still not able to add it to Secondary axis. Is there any reason why?

Hi Anonymous,

Not sure why do you need a secondary axis for this. What am I missing here?

Generally, you use a secondary axis, when you have 2 measures and their scales are different.

My assumption is this that you will be showing only 1 measure, bifurcated by the employee names.

I think what Idrissshatila suggested that you put the names as legends, should work!

Please provide sample data and result for us to understand the problem better along with your thoughts on why we need a secondary axis?

visheshjain Please guide me on this.

Hi Vishesh, the objective it to bring the data points closer so that they may coincide at some point. 

This is not possible in this case where there is significant difference between the two.

Hi Anonymous,

Again, not sure why do you want the data lines to intersect?

Still if you want this, then create a duplicate column for Employee Names in the same table.

Define 2 measures, in both measure use REMOVEFILTERS() for the other Employee name column.

E.g. For measure 1, remove Employee Name filter from the Duplicate Column

For measure 2, remove Employee Name filter from the Original Column

Then keep 2 slicers for employee names on your report page and edit the interaction between these 2 slicers. This way, your region filter both Employee Names columns, original and duplicate, but both Employee Names column will not filter each other.

Then put both the measure on your line chart and have the secondary axis.

In my honest opinion, you do not need jump through hoops just to get the lines to intersect 'visually', unless there a very good reason behind it.