Forum Discussion
Apply A Slicer Directly To A Measure
Hi,
I dont know how to share a table which can be pasted.
The problem I have is that tickets created and tickets completed are both dates
I have date of creation and date of completion
I would ideally like one slicer which is just DATE and anything is sliced by that date. But I do not have a DATE field, i have a 2 - create time and complete time.
If i sliced for February on create time, tickets completed are sliced wrongly. It will only show my tickets completed in february THAT WERE ALSO CREATED in February. I want tickets completed in February to be independant of anything else.
And I also want tickets created to be independant.
Can I just have a default DATE slicer?
You can open in Excel and copy and pasting your data from there into here. The Rich Text field will convert it to a readable table format. Also we can create a Date table from where your slicer is used and add relationships to your other tables.