Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

*URGENT* - Dual axis chart

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.

13 REPLIES 13
Anonymous
Not applicable

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

@Anonymous ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

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

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

 

Idrissshatila_0-1682494653508.png

 

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

Follow me on Linkedin

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

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

Satya_04_0-1682497186419.png

 

 

This is where I am standing.

 

Satya_04_1-1682497233001.png

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

@Anonymous , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

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?

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Anonymous
Not applicable

@visheshjain Please guide me on this.

 

Satya_04_0-1682497186419.png

 

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.

Satya_04_1-1682497233001.png

 

 

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.

 

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors