Clustered Bar Chart and Median Line

[ranjitsingh]

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]). 

@lbendlin 

[v-eqin-msft · Accepted 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

[ranjitsingh]

Actually I realized I didnt need to create a DAX measure. I used Analytics pane to get my line.

[mahoneypat]

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