Forum Discussion
Create a dynamic table with measures as columns
Here is my primary dataset I am working with
| Name | Day | Hours of work | ||
| Employee1 | 01-01-2021 | 5 | ||
| Employee1 | 02-02-2021 | 4 | ||
| Employee1 | 03-01-2021 | 1 | ||
| Employee2 | 01-01-2021 | 3 | ||
| Employee2 | 03-01-2021 | 7 | ||
| Employee3 | 02-02-2021 | 3 | ||
| Employee3 | 03-01-2021 | 5 | ||
| Employee4 | 01-01-2021 | 4 | ||
| Employee4 | 02-01-2021 | 5 |
I am trying to create a column chart with number of employees as Values and the number of hours as Axis. The day will become a date slicer.
As a first step, I am trying to create a dynamic table that changes as we change the date in the slicer. if the slicer has the earliest date as 01-01-2021 and the latest as 03-01-2021, My dynamic table has to look like below
| Count of Emplyees | Hours of Work | |
| 2 | 10 | |
| 1 | 8 | |
| 1 | 9 |
There are 2 emplayees worked for 10 hrs for the selected period
1 emplyee worked for 8 hrs for the selected period, etc
I wouod really appreciate if someone can point me to the right direction.
1 Reply
Anonymous , You need to create a table with generate series and join it back with measure hour and us that in analysis
Series = generateseries(1,100,1)
new measure =
Countx(filter(values(Table[Employee ID]), [Hour] = max(Series[value])),[Employee ID])
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
