Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So, Im trying to create a Line and stacked column chart of each technician and their pending status. So I want to show them on the chart and also incorporate our target which is 5% of the total
x-axis = technician field
column series = PendinStatus field (open, close)
target line= is 5% of each technician's total request
This means that target line should be relative to technician's number of closed request.
Can anyone help me with the target line computation? Im really new to this so kinda slow.
Solved! Go to Solution.
How's this for a Measure?
5% = CALCULATE(COUNT(Table1[Status]), ALL(Table1)) * .95
This will Count ALL Rows, then multiply by .95.
Proud to give back to the community!
Thank You!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |