Forum Discussion
*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
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 👍
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 👍
Idrissshatila For line chart, I won't get to have the legend as an option.
