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 a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
Solved! Go to Solution.
in general the method for user selection is via the Slicer; some good video tutorials on using these. You can have multiple within a page of a report. So I would first check out that information.
I can understand the idea of "slicing & dicing" data sets - but have always thought a more accurate name would be a Filter Selector......
make your first stab with these and then post if you need further assist.
@PauloH wrote:
Hi,
I have a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
You can create a independent calendar table used in the slicer and create a measure as
isShown = IF ( ISFILTERED ( 'calendar'[Date] ), IF ( MAX ( 'calendar'[Date] ) >= MAX ( Table1[start date] ) && MAX ( 'calendar'[Date] ) <= MAX ( Table1[end date] ), 1, BLANK () ), 1 )
To filter data, you can use a filter like
FILTER(yourTable, yourTable[start date]<= MAX(calendar[date])&&yourTable[end date]>= MAX(calendar[date]))
See the attached pbix file.
@PauloH wrote:
Hi,
I have a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
You can create a independent calendar table used in the slicer and create a measure as
isShown = IF ( ISFILTERED ( 'calendar'[Date] ), IF ( MAX ( 'calendar'[Date] ) >= MAX ( Table1[start date] ) && MAX ( 'calendar'[Date] ) <= MAX ( Table1[end date] ), 1, BLANK () ), 1 )
To filter data, you can use a filter like
FILTER(yourTable, yourTable[start date]<= MAX(calendar[date])&&yourTable[end date]>= MAX(calendar[date]))
See the attached pbix file.
in general the method for user selection is via the Slicer; some good video tutorials on using these. You can have multiple within a page of a report. So I would first check out that information.
I can understand the idea of "slicing & dicing" data sets - but have always thought a more accurate name would be a Filter Selector......
make your first stab with these and then post if you need further assist.
This had no relevant info to the question - not a solution
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |