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.
Hi,
I have created a measure called "Tenure Measure"
It works out the tenure of the employee by calculating the difference between year of hire and selected year from the slicer. And next it categorizes the tenure value into 1 of the 4 ranges: 0-3, 4-6, 6-10, >10
How do I show a bar chart with 4 bars (1 bar for each range) for the number of employees that are in each tenure range?
Solved! Go to Solution.
@Anonymous , bucketing on measure. For this you need an independent table. ANd you have to create an independent table and use that for creating additional measure which can give the count
refer my video - https://www.youtube.com/watch?v=CuczXPj0N-k
@Anonymous , Please check current Age measure and Age page in the file attached after signature
Refer to my blog, how it has been created
Hi Amit, thanks for the fast response as always.
I am able to calculate the Tenure measure, but I am struggling to convert the Tenure measure as a column.
Example:
I can see the tenure for each employee when i list the employee id (similar to the matrix visualization you have provided in current_employee.pbix, which has employee id as the 1st column), but i am interested in converting the "tenure measure" (which is expressed as a range 0-3, 4-6, 7-10, >10) into a bar chart.
Hoping to get something like this, which I have illustrated in excel.
Can you advise?
@Anonymous , bucketing on measure. For this you need an independent table. ANd you have to create an independent table and use that for creating additional measure which can give the count
refer my video - https://www.youtube.com/watch?v=CuczXPj0N-k
thank you very much! This works!!!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |