Forum Discussion
Helper IApply A Slicer Directly To A Measure
Super UserHi,
Share your data in a Table format which can be pasted in MS Excel. Also, show your expected result. Do not bother about the visual for now. Once we can get the numbers correct, any visual can be built from it.
Helper IHi,
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?
hnguy71You 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.