Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors