*URGENT* - Dual axis chart

[Satya_04]

I have a column named Employee Name and these names are to be brought into a dual axis form. 

Let's say region name is filtered and we are considering SOUTH.

Then we look for Employee Name within the region and select 2 names where both the names will be on value and secondary value. Please guide me on how this can be done.

[Satya_04]

@Idrissshatila This is a business requirement to have it as a line chart. I think this may work with DAX. Please share your thoughts.

[Idrissshatila]

@Satya_04 ,

maybe you could put the employees as legend so every employee have a line but it will be too much lines.

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

Follow me on Linkedin

[Satya_04]

@Idrissshatila For line chart, I won't get to have the legend as an option.

[Idrissshatila]

@Satya_04 , yes you could, and you could also do it as a small multiples.

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

Follow me on Linkedin

[Satya_04]

@Idrissshatila I could follow your approach. This is what I need.

This is where I am standing.

Please guide me on how this can be made similar to the one shared above.

[Idrissshatila]

@Satya_04 , check if this would help you .

https://youtu.be/gkMjAYFeSiM

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

Follow me on Linkedin

[Satya_04]

@Idrissshatila In my case, the value is going to remain the same and I'm not able to keep it in both value and secondary value - it could be in only either of these.

[Idrissshatila]

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

[Satya_04]

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?

[visheshjain]

Hi @Satya_04,

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?

[Satya_04]

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

 

[visheshjain]

Hi @Satya_04,

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.

[Idrissshatila]

Hello @Satya_04 ,

Instead of having a dual axis, you could put them both as hierarchy, like in a bar chart put region name and employee name and when you drill down south region you can see all employees under this region.

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

Follow me on Linkedin