Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a clustered bar chart showing salary as value and employee on the axis. I want to create a reference line to show employees that are above the median salary. Can I use the salary measure to create a median line ? For eg MEDIAN(Employee_Table[Salary]).
Solved! Go to Solution.
Hi @ranjitsingh ,
Yes, I agree with you. Adding a median/average line and so on in the Analysis pane is the easiest and most effective way.
Please kindly Accept your reply as the solution to make the thread closed. More people will benefit from it.
Best Regards,
Eyelyn Qin
Hi @ranjitsingh ,
Yes, I agree with you. Adding a median/average line and so on in the Analysis pane is the easiest and most effective way.
Please kindly Accept your reply as the solution to make the thread closed. More people will benefit from it.
Best Regards,
Eyelyn Qin
Actually I realized I didnt need to create a DAX measure. I used Analytics pane to get my line.
If you have a single row for each employee and the Value column has the salary for each employee, you can use an expression like this.
Median Salary = MEDIANX(ALL(Employee_Table), Employee_Table[Value])
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |