Forum Discussion
Employee count by Utilization segments
Hello Power BI Community,
I have a Power BI report where I am calculating the Employee Utilization%.
In the AttendanceTable there can be multiple records per each date for any employee.
Now I need to calaculate the employees count in different Utilization% segments like 0-10%,11-20%,....>100%.
I need to place these segments on x-axis of bar chart. The Employees count should be on the y-axis.
Additionally I need to display the details of all employees in a table visual, When any segment in the bar chart is selected, I will have to filter the table visual to show only employee who have fallen under that segment.
I already have the Utilization% measure which is calculated using the data from AttendanceTable.
Note: Each employee's utilization can vary from time to time. I have a timeperiod slicer on the canvas. When any enduser selects a timeperiod, the counts will change in each segment. Hence creating a utilization% column in the AttendanceTable didn't work.
Any help will be great appreciated. Thanks!!!!
2 Replies
- Ritaf1983Super User
Hi Prade
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
- AnonymousNot applicable
Hi Prade ,
You need a measure of utilization% instead of a calculated column.
Measures are dynamic while calculated columns are static.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly