Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@Anonymous you can use measure to show min/max line on analytic tab
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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.
@Anonymous 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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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).
@Anonymous 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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |