Forum Discussion
Manually enter or filter a value to change a column/filter
I have a list of employee IDs. I have a column of Active or Inactive that comes from the source system. I have a line chart that shows the hours they have worked over the last two years. In that line chart, I exclude the last 90 days before departure date of every Inactive employee.
I need to be able to enter an employee ID (filter, slicer, text search - I don't care as long as the end user can do it in the report) that will switch that employee from Active to Inactive in order to add them to the Inactive filter. That is, if we know someone is about to leave but they are not actually marked Inactive in the source system, I want to manually mark them as Inactive in the report.
Hi Anonymous
Due yo I don't know your data model, I build a sample table to have a test.
Build an ID Table with distinct ID value to build a Slicer.
ID = VALUES('Table'[EmployID])You can change the type of ID to Text, and then you can do Search in Slicer.
Build a Measure to achieve your goal.
Dynamic Status = VAR _Select = ALLSELECTED ( 'ID'[EmployID] ) RETURN IF ( ISFILTERED ( 'ID'[EmployID] ), IF ( MAX ( 'Table'[Status] ) = "Active" && MAX ( 'Table'[EmployID] ) IN _Select, "Inactive", MAX ( 'Table'[Status] ) ), MAX ( 'Table'[Status] ) )Result is as below.
In Default, the measure will show the same as the values in Status column.
Select one or multipy IDs in Slicer.(Ctrl+Left click) Here I select 001 and 010, they all show "Inactive".
You can download the pbix file from this link: Manually enter or filter a value to change a column/filter
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- Greg_Deckler
Community Champion
Anonymous - Perhaps you could use a What If parameter?
Greg_Deckler I tried that, since my employee IDs are numbers. But the parameter only goes up to 99999 (5 digits) and I need 7. I don't understand why it has a cap, but unless there's some trick to get around that, it won't work.
- Greg_Deckler
Anonymous - OK, then just create a separate, disconnected table for your employee ids.
Employees = DISTINCT(SELECTCOLUMNS('Table',"EmployeeID",[EmployeeID]))Something like that. Then you can use this as your "what if" parameter slicer.
Hi Anonymous
Due yo I don't know your data model, I build a sample table to have a test.
Build an ID Table with distinct ID value to build a Slicer.
ID = VALUES('Table'[EmployID])You can change the type of ID to Text, and then you can do Search in Slicer.
Build a Measure to achieve your goal.
Dynamic Status = VAR _Select = ALLSELECTED ( 'ID'[EmployID] ) RETURN IF ( ISFILTERED ( 'ID'[EmployID] ), IF ( MAX ( 'Table'[Status] ) = "Active" && MAX ( 'Table'[EmployID] ) IN _Select, "Inactive", MAX ( 'Table'[Status] ) ), MAX ( 'Table'[Status] ) )Result is as below.
In Default, the measure will show the same as the values in Status column.
Select one or multipy IDs in Slicer.(Ctrl+Left click) Here I select 001 and 010, they all show "Inactive".
You can download the pbix file from this link: Manually enter or filter a value to change a column/filter
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
