Forum Discussion
*URGENT* - Dual axis chart
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.