Power BI: Add slicer from measure
I have a list of working hours by date for every employee at a company and I have created a measure to calculate the total working hours. In the report I used a date slider so that the user can see the working hours by period. I now would like to create another slider which filters the employees by their total working hours in the given period. Say in the visual I would like to see who worked between 80-90% of the time on the dates between 01/03/2022-15/03/2022.
This has proven impossible so far since Power BI does not accept measures in slicers and I don't get how one would do this using calculated columns.
Any help would be appreciated.
Topic powerbi data visualization
Category Data Science