I have a column in my data named 'Duration' which is basically 'Termination Date' column minus 'Beginning Date' column.
I have another column named 'Duration within' where I can get the duration within how many years.
Now I can only get 0-1 years, 1-2 years, 2-3 years, and so on.
How to get 0-1 years, 0-2 years, 0-3 years and so on?
Because I want to make this as a slicer for the dashboard.
I know we can just multiple select for the slicer to get what I want. However, that is not the case, because I have a filter inside the data that filter based on the duration of the item.
Is there any way that I can do slicer that filter the original data at the power query level?
I can understand that you have a data table containing four columns ([Termination Date], [Beginning Date], [Duration], [Duration within]), then, you add [Duration within] into a slicer.
However, what do you mean 'have a filter inside the data that filter based on the duration of the item'? What is the filter? What is your desired output? Please share the screenshot of your report design and your expected result so that I can test for you.
Thank you for your reply.
What I am trying to achieve is to get a slicer where the user can select it.
I have found another way, but stuck with the measure problem.
Here is the link
I have read the thread from the link you provided. So, have you met your requirement now? If you still have any concern, please feel free to ask.