cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Dynamic compensation midpoint line on x-axis

I have a table of data based on Time In Position (TIP) and Total Base Pay Amount. We look at groups of individuals in each position in our company, and I need to visually see who falls at the midpoint and under the minimum point of our salary ranges for each position.

 

Is there a way to add in a dynamic line on the x-axis showing min and mid points? I tried the x-axis constant and Percentiles methods in Analytics under Visualizations, and that's not what I need.

 

Below is an example of the data I already have. I just need to add some dynamic lines for the data.

 

 

Time In Position by Base Pay.png

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Dynamic compensation midpoint line on x-axis

@stradlem you can use measure to show min/max line on analytic tab

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Regular Visitor

Re: Dynamic compensation midpoint line on x-axis

@parry2k  We tried the min/max lines on the analytic tab, but that shows us a line for the minimum point of data instead of the minimum of our range (the two are separate columns). Ideally, every point of data would be above our minimum of the pay range, as we strive to pay above the minimum of a pay range.

Highlighted
Super User IV
Super User IV

Re: Dynamic compensation midpoint line on x-axis

@stradlem doesn't matter if these are two different column, as far as your measure is returing the correct value it should work, try to check the value of your MEASURE wiht some other visual like table visual to see you are getting correct values.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Regular Visitor

Re: Dynamic compensation midpoint line on x-axis

@parry2k  I tried the min/max lines again per your suggestion. I'm only seeing the max and min for the top and lowest values (see picture below). I'm looking to display a line that shows the value of our compensation range's midpoint for each job (e.g. for this example, the line should show at $35,200 on the Total Base Pay FTE Amount axis).

 

Max and Min lines on scatter plot.png

Highlighted
Super User IV
Super User IV

Re: Dynamic compensation midpoint line on x-axis

@stradlem it is all in measure you wrote, and you can surely achieve this but need to tweak the measure, without looking at the data and what measure and relationship, it is very hard to provide the solution.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors