Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
@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 👍
Proud to be a Super User! | |
@Anonymous , 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 👍
Proud to be a Super User! | |
@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.
@Anonymous , check if this would help you .
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@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 👍
Proud to be a Super User! | |
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?
Proud to be a Super User!
@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.
Proud to be a 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 👍
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
84 | |
64 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |